Searching multiple MS SQL Tables
 

I would be grateful if anyone could let me know of an easy way of searching multiple tables for information.

I would like to display any found results in a grid alowing the user to choose the correct one and have this disply in the main form.

If this easy to do? I know it will need joins etc., but these are new to me.

Thanking you in advance.

Re: Searching multiple MS SQL Tables
 

If you are looking to pull out just one value (field) then this is simple enough. But databases are not like that, they're linked to different tables. How they are linked will depend on how easy it is to get the correct data out.

Re: Searching multiple MS SQL Tables
 

The tables are one table linked to three or four others (each of these are not link to each other)

Does this help?

Re: Searching multiple MS SQL Tables
 

Is it possible to show us a schematic of your tables, how they are linked and what are the primary keys etc.

Re: Searching multiple MS SQL Tables
 

Please find the information below, thanks for you help.

Re: Searching multiple MS SQL Tables
 

I can barely read that text can you post a picture where all the text is big and clear to read. Thanks.

Re: Searching multiple MS SQL Tables
 

Is this better?

Re: Searching multiple MS SQL Tables
 

Hi,

what u actually want..? Search all the fields of all the tables for any one Specific condition...?

-Vee

Re: Searching multiple MS SQL Tables
 

Vee, well put that is what I want.

I know this seems strange, but the old DB (propitiatory) can do this and they want to keep that functionality.

Re: Searching multiple MS SQL Tables
 

Hi,

What is the Database u r using..? Access..?

-Vee