I am having trouble finding out how to add multiple records from a lookup
table to a single record in another table.
Tables:
Metro Areas (just a look up table)
Service Technicians (includes field to lookup MetroArea)
I have some technicians who cover multiple metro areas, and want them to
show up in these different areas at reporting level.
I have created a form to add a new technician (data from the Service
Technicians Table). If I add the field for the metro area lookup, I can
only enter one Metro Area per tech. I am sure this is a basic question - but
I'm finding it harder to search for the answer than to ask.
Thanks,
Robin
George Nicholson - 06 Mar 2007 22:29 GMT
You need a Junction table to hold the ServiceTechMetroArea data:
ServiceTech MetroArea
A X
A Y
A Z
B M
B T
B X
ServiceTech>ServiceTechMetroArea is 1:M relationship
MetroArea > ServiceTechMetroArea is 1:M relationship
HTH,
>I am having trouble finding out how to add multiple records from a lookup
> table to a single record in another table.
[quoted text clipped - 14 lines]
> Thanks,
> Robin