Dynamic Selectbox
Posted: Tue Jul 28, 2015 6:11 am
Hi,
I'm trying to populate 3 different select boxes, based on what was selected from the previous selected value.
Select box 1 is populated by default using a database file and choices selection criteria. (CPKEY1 = 'CALLTYPE').
DB File Layout:
CPKEY1,
CPKEY2,
CPDSC1
etc.
Sample Data:
CPKEY1 CPKEY2 CPDSC1
CALLTYPE 1 MEMBERSHIP
CALLTYPE 2 AUTHORISATION
CALLTYPE 3 PRICING
CALLTYPE 4 SCHEME RULES
CALLTYPE 5 CLAIMS
CALLTYPE 6 FORMULARY
CALLTYPE 7 OTHER
CALLTYPE 8 INCORRECT MEMBER SELECTED
CALLTYPE 9 OPTIPHARM ENQUIRIES
CALLTYPE1 1 Member Number Required
CALLTYPE1 2 Dependant Code Required
CALLTYPE1 3 Date of Birth Required
CALLTYPE1 4 Eligibility of Member Confirmed
CALLTYPE1 5 Other
CALLTYPE1 6 Waiting Period Applied
CALLTYPE1 7 Scheme Option Confirmed
CALLTYPE1 8 Membership Suspended
CALLTYPE2 1 Authorisation Required
CALLTYPE2 10 Authorisation Letter Required
Select box 2 now needs to be build, based on what was selected in select box 1. If Selectbox 1's selected value is "MEMBERSHIP", the value of the key to access the file will become "CALLTYPE" + CPDKEY2 (1 in this case), and so selectbox 2 needs to show data for CPKEY1 = "CALLTYPE1".
I need to populate the select boxes in a pop-up screen, without sending a request back to the server.
Any help would be highly appreciated.
Regards,
I'm trying to populate 3 different select boxes, based on what was selected from the previous selected value.
Select box 1 is populated by default using a database file and choices selection criteria. (CPKEY1 = 'CALLTYPE').
DB File Layout:
CPKEY1,
CPKEY2,
CPDSC1
etc.
Sample Data:
CPKEY1 CPKEY2 CPDSC1
CALLTYPE 1 MEMBERSHIP
CALLTYPE 2 AUTHORISATION
CALLTYPE 3 PRICING
CALLTYPE 4 SCHEME RULES
CALLTYPE 5 CLAIMS
CALLTYPE 6 FORMULARY
CALLTYPE 7 OTHER
CALLTYPE 8 INCORRECT MEMBER SELECTED
CALLTYPE 9 OPTIPHARM ENQUIRIES
CALLTYPE1 1 Member Number Required
CALLTYPE1 2 Dependant Code Required
CALLTYPE1 3 Date of Birth Required
CALLTYPE1 4 Eligibility of Member Confirmed
CALLTYPE1 5 Other
CALLTYPE1 6 Waiting Period Applied
CALLTYPE1 7 Scheme Option Confirmed
CALLTYPE1 8 Membership Suspended
CALLTYPE2 1 Authorisation Required
CALLTYPE2 10 Authorisation Letter Required
Select box 2 now needs to be build, based on what was selected in select box 1. If Selectbox 1's selected value is "MEMBERSHIP", the value of the key to access the file will become "CALLTYPE" + CPDKEY2 (1 in this case), and so selectbox 2 needs to show data for CPKEY1 = "CALLTYPE1".
I need to populate the select boxes in a pop-up screen, without sending a request back to the server.
Any help would be highly appreciated.
Regards,