Three Drop down lists from the same table

Hi All,

This is my first post , I have a table "Medicine" with fields as med_name,med_code,exp_date,balance I want to design a form where the user has to first select medicine name from first drop down , based on the medicine name the second drop down is populated from the same table with all exp date data , it is possible that the same medicine name is having different exp date and quantity , based on the selection of the exp date the third drop down is populated with the balance medicine and this data is read only , in the forth option the user can input the quantity of medicine which should be less than or equal to the third read only box of balance , once submitted the medicine table is updated and the balance is reduced by the amount selected.

After that I shall post some more help

Please Login to post your reply or start a new topic