Hi, I have this form named school.
On the heading I have drop down list that lists all the name of the schools in the table school. And within the form school is the sub form name presentation.
When I changed the drop down list, all the values of the school form and presentation changes according to school id.
But I want to set the values of certain fields to be drop down list also. For instance, presentationID, in form form presentation (which is currently text box) to be a drop down list that list all the list of presentation id since 1 school can have more than 1 presentation ID. And also, I would like to select the drop down list so that when I click all the datas to be changed according to it.
Can somebody help me on this issue please...
On the heading I have drop down list that lists all the name of the schools in the table school. And within the form school is the sub form name presentation.
When I changed the drop down list, all the values of the school form and presentation changes according to school id.
But I want to set the values of certain fields to be drop down list also. For instance, presentationID, in form form presentation (which is currently text box) to be a drop down list that list all the list of presentation id since 1 school can have more than 1 presentation ID. And also, I would like to select the drop down list so that when I click all the datas to be changed according to it.
Can somebody help me on this issue please...