Date field that shows only related dates

[kelkan]

I have a table that lists classes available (tblCourses); one that lists class dates (tblDates) and another that lists employees (tblEmployees). I have a fourth table that combines that data into classes taken by the employee (tblTraining). I have a form to input the employee's training with combobox fields for the COURSETITLE and CLASSDATE. I want the CLASSDATE field to only display the dates available for the specific class that was selected. How do I do that?

[June7]

Sounds like need dependent (cascading) comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html