|
| Have been using access for about a year very limited. Trying to create a database using multiple tables and tying them all into one form. Have done this multiple times but am running into a problem on this one. Some records from one table need to be tied to multiple records on another table. Example is this- creating a table that has employee info and what locations they are in charge of, other table is of location information. the problem is that some people are in charge of multiple locations, using the location ID number as a primary key means I can only tie the employee to one location. need to be able to tie them to multiple locations. Want the location info to be the main one on the form and employee info to be the sub form so that the employee info can be listed on multiple location, so that is why this is causing me problems.
Hope I didn't explain this to confusing.
thanks | |
|
Microsoft Access
