Is this thought even possible?

[TOMMY.MYERS668]

I have a db that lists all of the classes we teach for a year. I have a table that list what each instructor is certified to teach by a multiselect combo box. Can I make a dropdown on the classes db(msr) that will only list instructors certified to teach that class based on the other table? That part maube easy considering some things ive allready made access do... But if so part 2 comes in and that would be that once an instructor is selected that I would need them to not be available to be picked for another class during the same dates...
Any thoughts?

[June7]

Can I make a dropdown on the classes db(msr) that will only list instructors certified to teach that class based on the other table?

Yes, that is dependent (cascading) comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html

once an instructor is selected that I would need them to not be available to be picked for another class during the same dates

Doable, but tricky. The combobox RowSource would be a query that joins the instructor table to classes scheduled table. Can't be more specific without knowing more about data structure. If you want to provide db, follow instructions at bottom of my post.

[TOMMY.MYERS668]

Ok back to work for the army again for a few weeks...just letting you know that this msr db is the hot thing right now.. Have classes input and a couple test instructors in the certified table honda read that link on cascading combo boxes.. On my phone right now so I can't upload the db.. Just kind of a heads up I'm working on this again.