Search using drop downs
I am currently working on a database on the ipad for use at school. The database is running well but I now need to move into functionality and am struggling with the whole area of scripting finds.
Here's what I need to do and would appreciate some ideas and guidance on.
The database records the ethicity of students (Maori, NZ European, Pasifika, Other) and then also records lots of academic details, test results, reading age etc.
What I want to be able to do is have a drop down menu to select an ethnic group then another drop down where I could for example select a reading age and then get a figure for the number of those students who are at or are above that level. I could also then use that infor to calculate the percentage compared to the whole group.
I undertstand the maths to do the calculations but am struggling with how to script 2 dropdown boxes and have them search and complete the calculation. No doubt it is easy but help would be appreciated thanks.