Question Selecting from a List?

[Minnesota]

I'm putting together a database to select and assign locations to employees. Each manager will assign between 5 and 25 locations at one time to one employee. The list will consist of somewhere between 500 and 1000 locations and will forever be growing as more locations come in.

What I'm having a hard time with is how the manager will select the locations, then get the list of chosen locations to the employee.

I have thought about having a form to allow the managers to see a list of unassigned locations. Then they could, somehow, select the 5 to 25 locations of choice and assign them to an employee. Then the selections would go under the already assigned category so as not to be assigned a 2nd time.

Any guidance or sample databases that would do similar functions? I'm constantly searching and I've yet to find something like this.

 

[pbaldy]

I think this will help on selecting the records, presuming your table layout is what I think it should be.

http://www.baldyweb.com/MultiselectAppend.htm

 

[HiTechCoach]

I something do this with a form. I put the list of all the locations into a temp table with a check box for the selecting the items. I then markt he onces that are currently select.

The user can then select or un-select items. When the click "update" I append in the new selected records, and delete the ones that were un-selected.