I’m wondering if it is possible to do a search for database that is 2 or 3 lists levels in?
For example: database USER has a list of COURSES. COURSES consist of a list of GRADE (e.g. grade 11), NAME OF THE COURSE (e.g. Math) and whether or not the COURSE is currently being taken by the USER (Yes/No).
I would like to create a list consisting of all the USERS that has “Math” education of GRADE “11” or higher, but not if the USER is currently taking this COURSE (ie. the data field CURRENT COURSE = NO).
In my app, “Math” and “11” are both input fields. I’ve tried to set the search constraints, but once I go into COURSES, I am not able to go deeper into the list, to select CURRENT COURSE = NO or GRADE is >11. Can anyone help please!?