Searching Many Tables in Various Databases?

[adenwalker]

Can anybody help me?

I have a table: Book and another: Copy. How can i search these two tables so when a user finds what they are looking for it show the record in a form not a table. Also is it possible to search tables which are link to the database from another database?
Thanks
Aden

P.S. I have tried the sample search database but could not get it to work!

 

[ColinEssex]

If both tables have a common link then use them in a query to populate a form, then you could use a ComboBox as your search tool.

You can link to external tables via the link table wizard.

Col