billythedj66
Board Regular
- Joined
- Jan 6, 2003
- Messages
- 126
In our database, we have a form specifically for searching purposes.
e.g. Job Location (combo box), Foreman (combo box), Job Description (combo).
After making a selection from the "Job Location" combo box, is there a way to automatically list in the Foreman combo box, only those foreman that have a worked in that particular "Job Location" selected from the previous combo box. And then automatically list in the "Job Description" combo box, those job descriptions that fit the "Job Location" and "Foreman" criteria that have been selected. In other words, we are trying to sort by narrowing down the each combo box based on the selections from the previous combo boxes. FYI, each Job description is unique. Any help would be greatly appreciated.
[/quote]
e.g. Job Location (combo box), Foreman (combo box), Job Description (combo).
After making a selection from the "Job Location" combo box, is there a way to automatically list in the Foreman combo box, only those foreman that have a worked in that particular "Job Location" selected from the previous combo box. And then automatically list in the "Job Description" combo box, those job descriptions that fit the "Job Location" and "Foreman" criteria that have been selected. In other words, we are trying to sort by narrowing down the each combo box based on the selections from the previous combo boxes. FYI, each Job description is unique. Any help would be greatly appreciated.
[/quote]
