Example: Dependent Dropdown
Often you'll need a form with two dropdowns, and one dropdown's values will be dependent on the value of the other dropdown. This sample online database shows how to create a dynamically dependent dropdown list.
Description
Suppose there is a States table and a Cities table - the City refers to State.
If you are implementing Addresses table, obviously it is enough to have a relation to the City - the State could be looked up from Cities table.
However if you want the user to select State first and then the City from the state-restricted list you should first add a relation from Addresses to a State - this will render States as a dropdown - and add match condition to the Address-City relationship to match City.State and Address.State.
Screenshots
To help you make the system work for your needs, we have developed the following service program:
- Discuss your needs with our staff.
- We’ll determine and confirm the workflow logic of your database.
- We’ll create a ready-to-use database to fit your exact business model.
- You’ll get a solution designed especially for your needs.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.
We offer free system configuration assistance
(up to 4 hours of consulting work).
If you decide that our database is not exactly what you need - you owe nothing.