The infomaker application connects to the SQL Server database. This is where the data comes from (there is a table lets call it LT_DATA).
LT_DATA has the following
ID PROGRAM Curriculum
1 Elementary Europe
2 Elementary Asia
3 Elementary Africa
4 Secondary Australia
5 Secondary Europe
The infomaker has two menus.
The user selects Program in one menu and prior to hitting save the user will select a second menu. The second menu needs to be filtered by the first. So if the user selects Secondary Program in the drop down menu the second one should only show Australia and Europe.