Hello everyone,
I'm building my first Access database since 1997 or so and need a little help. In the form I'm creating I have a dropdown selection that is fed by the table Events. Events has an ever growing list of test events that we will be doing. As each new test is added, a new set of test cases will be be added to the table Test Cases that belong to that specific event.
In the form the employee needs to first select the Event and based on that selection, I would like to have another dropdown where they select the test case they will be preforming. I need this dropdown to limit their selection to one of the Test Cases assigned to that Event. How do I do this?
Thanks in advance for your time and help,
Keith