467,864 Members | 1,918 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,864 developers. It's quick & easy.

populating one list box from multiple tables. Can it be done?

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

Oct 18 '07 #1
  • viewed: 1748
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Sidney Linkers | last post: by
6 posts views Thread by Chris Leuty | last post: by
6 posts views Thread by p.mc | last post: by
4 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.