Can we have two tables linked to one search query? I've some data that is confidential and woul like to have them in two different table. When I search for it using query form, only the relevant table results will be shown? Thanks! 
can we have two tables linked to one search query?
- Thread starter leftright
- Start date
Yes. Say I have a succession planning database. One table consist non executive information. I now want to create another table for executive informstion (which are confidential so I'm separating it out to another spreadsheet). Is it possible to join both tables to one query, such that when I search the name of non executive, information will come from the non exec table, and if I search an executive name, it'll come from the exec table? Thanks!
pr2-eugin
Super Moderator
- Local time
- Today, 18:54
- Joined
- Nov 30, 2011
- Messages
- 8,494
Yes you need to split the information and then link them up with a Common ID, this is called Relationship. Then once the two tables are sorted, you can create two seperate queries, one with the exclusive information and the other with non exclusive.. So based on what query is called you will get the appropriate information..
baldmosher
New member
- Local time
- Today, 18:54
- Joined
- Oct 31, 2013
- Messages
- 9
If I've read this correctly, I think the short answer is no.... I'm a little confused by how you expect to police this, unles it's only you who will be accessing the confidential information? If so, I guess you just don't want to work out which query to use?Yes. Say I have a succession planning database. One table consist non executive information. I now want to create another table for executive informstion (which are confidential so I'm separating it out to another spreadsheet). Is it possible to join both tables to one query, such that when I search the name of non executive, information will come from the non exec table, and if I search an executive name, it'll come from the exec table? Thanks!
The long answer is yes, as per the last comment above; you will need separate queries to search within each data set, and you also need to somehow determine whether the search term used was for an exec or non exec, and run the appropriate query to search the correct info. A simple form should do the trick or you could use VBA to determine the result logically.
Logically, it's simple. Setting it up, very long-winded!
