I have two database table tblTelephoneSuppliers and tblTelephoneCallPlans. tblTelephoneCallPlans which has fileds TelephoneCallPlansID, TelephoneSuppliersID and TelephoneCallPlanName. tblTelephoneSuppliers has fields tblTelephoneSuppliersID and TelephoneSupplierName.
I have a dropdown list which retrive all the telephone suppliers from tblTelephoneSuppliers on that dropdown list. I also have another dropdown box. What i want is when a selected item is selected from the dropdown list, the call plan for that supplier to be shown on dropdown list 2.
I've done the store procedure like this:
CREATE Procedure sp_getTelephoneCallPlans
From tblTelephoneCallPlans TS
Enabled <> 0
TS.TelephoneSupplierID = @TelephoneSupplierID
the drop down supplier list store procedure is done like this:
CREATE Procedure sp_getSecondSupplier
Enabled <> 0;
Now how would i do the backend and front end coding so when a value from dropdown list 1 is selected its correspondent plans to be shown on dropdown list 2.