Hello All
I have found it a bit difficult to explain my question so I will use a scenario.
I am designing a form with two fields to enter data on Vehicle Make and Model. I have one look up table with vehicle makes and another with all the models. They have been designed to come up as 'scroll down menus'
How do I design it in such a way that if I enter the name of one Make e.g Nissan, the look up table (or scroll down menu) for Model will only list Nissan models NOT the full list of models
I have found it a bit difficult to explain my question so I will use a scenario.
I am designing a form with two fields to enter data on Vehicle Make and Model. I have one look up table with vehicle makes and another with all the models. They have been designed to come up as 'scroll down menus'
How do I design it in such a way that if I enter the name of one Make e.g Nissan, the look up table (or scroll down menu) for Model will only list Nissan models NOT the full list of models
