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
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