hi guys, I would greatly appreciate it if you could help me with this code
I have some tables called,
Student (SID,SNAME) -> I have got data into it
Course(CID,CNAME) -> I have got data into it
Take(SID,CID) -> I have got data into it
quesion (CID,QNO,MRKS)-> I have got data into it
answer (SID,CID,QNO,ACTUALMRKS) ->I need to insert data into it?
Now I want to display CID as drop-down menu from Take table
if I select a data from above the drop-down menu then another drop-down menu should create automatically with the SID form Take who is taking particular CID.
If I selected both field then QNO (should come from the question table) and a extra text field (depend on how many QNO has itself) has to create automatically to enter ACTUALMRKS.
if I submit then all data has to store into the answer table