Morning all! :)
I have a database with multiple linked tables.
I have created a search form with one txt box, for entering search
criteria, and a listbox for each of the tables to isplay the results
from that table.
These list boxes work well, but they are now cluttering the screen.
My ideal scenario would be one listbox where the results specific
fields from all the tables are displayed.
i.e. the users would see something like this on the search form.
Search Criteria : [Statue of Liberty]
"Your Search Returned the following Results"
Listbox Headers: matchingfieldcontent tableName,
Statue of Liberty tblStatues
Statue
tblLandmarks
Statue5 tblLandmarks
Statue of Liberty tblImages
and so on, displaying all records which can then be double clicked to
open the record.
I have looked at some examples of additem method, but everything i
have seen seems to point towards only 1 table being used to search.
Also the tables linked to the database are not related, so i cannot
create a query based on those tables. (and yes i know about
normalisation etc, but these are all inherited tables and i do not
have organisational permissions to do anything with them but link them
in! :)
I am simply looking for a way to search through specific fields in
each table with a text string and populate the listbox with the
results.
There must be a way to get the listbox to display results from
multiple tables?
Help is, as always, really appreciated