Forgive the question and probably the wrong terms that I'm using...it's been awhile since I regularly used Access beyond the VERY basics.
If someone can point me in the right direction, I can probably dig up the instructions on my own...but since I don't even know what this is called, I can't even begin to search. haha
I'm building an NCR (non-conformance report) database for work. I need to create drop down menus that only show valid results based on the previous selection.
As an example, using something we are probably all at least somewhat familiar with, say you were building a database of cars.
You would have a Table of Cars:
Tahoe
Cadillac
Corvette
Camaro
Explorer
The user would select the first option from the form:
Number of Doors: (drop down) 2, 4
Based on their selection on that drop down, the following choices (cars) would be reduced to only those cars with 2 or 4 doors. So if the user selected "2 doors" the next menu would only show "Camaro, Corvette"
Is this down through queries? Essentially filtering a table based on the value of a column?