add multiple records to a single record in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
 
Back
Top