I am currently working on a database and I’m having some touble by filtering it.
I have two databases: one is called professor and another one is class.
The professor database has two fields: name and a list of classes; and the class database has the same two fields: name and a list of professors.
I’m using search & autocorrect two match an input field to the professor’s name and I wanna to do a filter based on the class’ name, but I can’t do it. When I go to the search & autocorrect datasource and try to add a constraint based on class’ name, all I got is a contains or not, but it won’t work because it returns only a yes or no, not the professor filtered by the class.
Hope someone is able to help me