Use of a ComboBox an a form. How would I do this?

  • Thread starter Thread starter Intruder via AccessMonster.com
  • Start date Start date
I

Intruder via AccessMonster.com

I have 2 tables An Employee table with an autonumber EmpID, FirstName, Last
and EmployeeID. The other table LOCKERS contains an autonumber ID, Locker #,
Type (M,F), Key Number. What else do I need in the LOcker table as far as
fields? On a form how do I use a combo or list box to see what lockers are
avalable to assign to an employee. An employee can have more than 1 locker.
When a locker is assigned how do I get it to not appear in the list anymore??
I am pretty new to this and need help that a basic user could use to get me
here, Thanks
 
An employee can have more than 1 locker.

OK, but can a locker have multiple employees assigned to it at one time? If
not, then I think you also need a "EmpID Assigned" field in your lockers
table.

If the field is filled in, the locker is assigned. To get a list of
unassigned lockers, create a query using (EmpIDAssigned = "") as criteria.

HTH,
 
If the field is filled in, the locker is assigned. To get a list of
unassigned lockers, create a query using (EmpIDAssigned = "") as criteria.
Click to expand...

or better - EmpIDAssigned IS NULL

John W. Vinson[MVP]
 
Back
Top