So I am having a couple problems and I will start by explaining what I'm trying to do.
I maintain a database of lockers and I have to assign a group of about 130 lockers every 2 months. There is a seperate set of staff lockers and student lockers, and I have both book and clothing lockers that need to get assigned.
When a new class shows up there is another access database from which I import the new class data, and then take that data and put it into a master personnel file.
So the tables I have are Personnel info (this is the master file), with fields: SSN, LAST_NAME, FIRST_NAME, CLASS#, Gender (Gender is for assigning female/ male clothing lockers and there are other columns but they are not relevant to what I want to do). Then I have locker assignments by SSN, with fields SSN, Physical Condition (Works or Broken), Purpose (Staff, Student, Staff/ Student Overflow), Locker#, and Gender for the clothing lockers.
What I would like to do is have access ask me for a class# input and assign this class lockers that are empty based on the criteria Purpose ="Student" or "Staff/Student Overflow" and Physical Condition = "Works" (and Gender in the case of the clothing lockers).
Any help would be greatly appreciated. I have been using access programs for a long time but this is the first one that I have actually took on to make the program. I am not opposed to using visual basic with some guidance.
Thanks in advance!
Josh