Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / March 2007

Tip: Looking for answers? Try searching our database.

add multiple records to a single record in Access 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rcvallier - 06 Mar 2007 21:29 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.