cascading Combo Boxes.
I have front end to an SQL database that requires drop down combo boxes. I have seen and used combo boxes from the forum. The problem I have at the moment is the underlying database structure.
A batch is a Sub division of a Release
The is the server table that holds a Batch_ID from Tbl_Batch. From there the Servers release NO can be worked out as tbl_Batch has a Release_ID from tbl_release
Tbl_Server Tbl_Batch Tbl_Release
Server Name Batch_ID Release_ID
Batch_ID batch_Name Release_NO
Release_ID
The requirement for the front end is to allow a user to select a release 1 to 5. This will automatically clear the batch to the default batch for the new release. However the will also be a drop down for batch that will depend on which release the server currently is in.
Has anyone had any experience to trying to create Cascading combo boxes dropdowns with the data structure described above?
Thanks
I have front end to an SQL database that requires drop down combo boxes. I have seen and used combo boxes from the forum. The problem I have at the moment is the underlying database structure.
A batch is a Sub division of a Release
The is the server table that holds a Batch_ID from Tbl_Batch. From there the Servers release NO can be worked out as tbl_Batch has a Release_ID from tbl_release
Tbl_Server Tbl_Batch Tbl_Release
Server Name Batch_ID Release_ID
Batch_ID batch_Name Release_NO
Release_ID
The requirement for the front end is to allow a user to select a release 1 to 5. This will automatically clear the batch to the default batch for the new release. However the will also be a drop down for batch that will depend on which release the server currently is in.
Has anyone had any experience to trying to create Cascading combo boxes dropdowns with the data structure described above?
Thanks
Last edited: