table How to Search an Entire Table

[aewilcox10]

I recently set up a virtual field so that my search bar would search across multiple fields. Now, I want to add some drop down boxes to help eliminate some results. For instance, this database includes scholarship information for students. I want them to be able to type a keyword that will be searched across the entire table. Let's say they type "Astronaut." The Astronaut Scholarship will appear. But let's say this student is not a US Citizen and can't apply as a result. I want to insert a drop down box (which corresponds to a citizenship field I have in the table) that would search Astronaut across the entire table, but remove anything that didn't also meet the citizenship requirements. Is it possible to do this? The online chat support person said I would have to do a virtual field, but because I have a free account, couldn't give me more information (understandably).

[aam82]

If you code your scholarships datasource with a citizenship field

scholarships

name, type, citizenship

 

and your Users table with a citizenship field

users

name, email, citizenship

 

Then you can make a Scholarships Report, with Record Level Security, based on:

Identitiy field in Authentication: Users_Citizenship

Matching field in current data source: Scholarships_Citizenship

[NailDyanC]

Hi just to add in the previous comment above, I think this related forum might help(See last comment): 

*You just need to include all your fields in one formula field