Jump to content
  • 0

How to Search an Entire Table


aewilcox10
 Share

Question

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).

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...