Denise2020
Member
- Local time
- Today, 02:12
- Joined
- Mar 31, 2020
- Messages
- 82
I have a database with multiple tables I will call ExtAssist, AmData, and Library. The ExtAssist table is used to document "incidents" where agencies call us for help about an object. The AmData table contains the objects list that we have in our file system. The Library table is a database of all media we have in our library (books, cds, etc.).
The tables have no direct relationships to each other. The ExtAssist incidents will refer to an object which may or may not be something in our AmData or Library tables (ie we may have information about it in one of those tables).
I currently have three forms, one for each table, with a string search text field where I can search, for example, "m/25" and any objects with that in the name will come up if it is mentioned in each of the tables. What I would LOVE is a fourth form with a simple text search (browser-like) where users could search "m/25" and would get a list of all the posts listed in EITHER of the three tables that mension that search term. Is this asking too much? I have tried to search how to do this but am afraid I am not even using the correct terminology to try to find an answer.
To clarify, I do not want to join data, I just want a list of results from any and all of the tables where the search term is mentioned, all the books, all the incidents, all the files. Is this possible? Thanks in advance!
The tables have no direct relationships to each other. The ExtAssist incidents will refer to an object which may or may not be something in our AmData or Library tables (ie we may have information about it in one of those tables).
I currently have three forms, one for each table, with a string search text field where I can search, for example, "m/25" and any objects with that in the name will come up if it is mentioned in each of the tables. What I would LOVE is a fourth form with a simple text search (browser-like) where users could search "m/25" and would get a list of all the posts listed in EITHER of the three tables that mension that search term. Is this asking too much? I have tried to search how to do this but am afraid I am not even using the correct terminology to try to find an answer.
To clarify, I do not want to join data, I just want a list of results from any and all of the tables where the search term is mentioned, all the books, all the incidents, all the files. Is this possible? Thanks in advance!