Access Question

[Woland]

I want to assign lockers to students. I have a student information table and a table that has all the lockers/locations/combinations. I have a locker field in my student information table that can look up the locker numbers and related information.

What I want to know is this. Is there a way to remove from my look-up list those lockers that have already been assigned to the student information table?

 

[Woland]

Right now, I am just working with tables and using the look-up wizard under the data type for the field. I haven't created a form yet because its much easier to enter the data when I am looking at the whole table.