add multiple records to a single record in Access 2003

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
 
G

George Nicholson

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
LU table getting records added 6
Trying to combine multiple records into one record in a Query 1
Copying field value to multiple records in same table 1
Merge multiple records in a field, based on criteria? 2
Multiple Options On one record ties to a look up table 4
Add "Record Created On" Field to a Query 5
Access Form - Lock Fields from Editing 0

Top