Can you be a little more specific? Do you mean if the student is, for example, in the Physics group (major) he only sees Physics classes?

Yea unless your talking about something else. A many to many junction table is all that you need. One table with classes and another with the students. Now if your saying you want to filter your results down, that can be done in numerous ways. I dont know how your database is setup but if you have the customer and classes table setup. I would just add a field to the customers table that you could enter in a major. Then you could make a one to many relationship between major and the classes. You could then limit what courses are offered to him by his major.

You could also just use a filter or where clause, or you could just manually assign the classes to the student with the junction table. Access always seems to have lots of ways to get to the same end result. Just depends how your tables and form is setup now and what you want to do.

Close. Lets say at a workplace I have a maintenance department with multiple employees and positions within the department. The electrician and foreman need to be trained on electrical safety but the general mechanic doesnt. Employee John (electrician) and Frank (foreman) need electrical training but Joe (general mech) doesnt. I would like to see the employees assigned training based on the employees position. The department would be irrelevant. These would populate in the training sub form in the employee form.

Thanks Adam for the guidance. I worked on this again today and still struggled. I have two many to many relationships and I am stuggling to make them connect. For instance, in my scenario described the maintenance person can learn another protist ion which has different assigned training. It like the person ilmahoring in physics may have a double major in math as well lol

Hey Edwards, If you don't have it figured out by later today I'll come up with something. My server got fried yesterday and today has been absolute chaos so my brain just isn't working right now. When things calm down later I'll try to give you some ideas. I assume you also need to track if the training has been completed by a specific employee?

I got close today by nesting my subforms. I can see the specific course per employee depending on their position. It would be great if I could keep  track of when that training is completed and expired per the TechHelp video in the nested subform. I do need to track training by employee.

Maybe Rick can chime in. I don't know if it was because of all the work chaos, but this question was really boggling me. I'm sure there's a better way but this is what I had working. You can't control the complete check because it's a dlookup but I assume you would do that in another form linked to controlling EmployeeXTrainingT anyways.

I'm under the assumption that the goal of this is just to get a list of classes available to showup on the subform based on job position and see if they're completed or not. This should be able to cover that. If you need more I'm going to need a beach vacation first LOL.

Made a query for the subform to filter trainings offered to employee based on job position, then made a dlookup in the checkbox record source to check if the course has been completed or not.

=Nz(DLookUp("Complete","EmployeeXTrainingT","EmployeeID=" & [Forms]![EmployeeF]![EmployeeID] & " and TrainingID=" & [TrainingID]),False)

I'll include some images too. Hopefully this helps you.

You basically just have multiple many-to-many relationships. Each employee has a department, but separate from that they have a job title. The training could be based on job title. It's all how you want to set it up.