Table setup

[MFS]

I have table of employees, as well as a table of
locations. Some, but not all, employees work at multiple
locations. I currently use a form, with a drop down
linked to location table, but this will only select one
location. What's the best way to select multiple
locations, as well as assign a percentage of time spent
at each location, for budget purposes. THis percentage
will remain constant, but different for each employee.

 

[Con]

Hi,
This is a one to many relationship.
You'd be better off showing the locations in a listbox for each employee.
Then use the dropdown box to add another location for an employee to the list box
hope that makes sense

 

[Lynn Trapp]

You need a third table called EmployeeLocations. It would only need 2
fields -- EmployeeID and LocationID (I'm assuming that you have used those 2
fields as the primary key for your current 2 tables but, if not, you need
fields that will match the primary keys of your tables). Then you can create
a subform to pick multiple locations for each employee.