Simple Problem - Linked Tables?

[lukasgill]

I have 3 tables.

One table has a whole load of data: (table 1)
date, name, company name, building Name, etc

I have one other table which holds company names (table 2)
I have one other table which holds Building Names (table 3)

The main table is linked to the other tables so in the company name of Table 1 , the ID from the entries in Table 2 are shown.
As is the building names section in Table 1 shows the ID from the entries in table 3.

Now, this is all fine and well...but when i create a search form which displays the list of results, and lists them showing their name, date, company name, building name etc...the Company name and Building name only show the ID's still.
Is there any way to show the actual entry rather than the ID of the other tables entry?

I hope this makes sense, i'm not the best explainer.
To put it simply, i want the real company name showing in the search, rather than "1" or "2" or "3" etc...


Thanks!

 

[neileg]

Join the tables in a query and retrieve the names instead of the ID. Base the search on the query.

 

[lukasgill]

Do you mean, create a query with the two tables and link the 2 tables by the ID and the Name?

 

[neileg]

Your link field should be the ID, not a name.

 

[lukasgill]

Got it, thanks for the help