Combine data from another table using query expression

[trident]

I have several table connected to the Main table. In the main table, only the ID no is save from the other tables to save space. Now in the query I am creating I am trying to get the data in the other table.

sample is:

Main Table: connection Sample

Company ----- CoID, CoName 1 WSD
Section ------- SctnID, SctnName 2 HelpDesk
Year ------------ No connection 15
Reference No -- No Connection 20003

I am trying to create an expression wherein the CoName and SctnName from the other tables will appear instead of the CoID/SctnID which is saved in the main table:

Company-Section-Year-Reference No

This is my expression:

[MainTable].[Company] &"-"& [Maintable].[Section] &"-"& [MainTable].[Year] &"-"& [MainTable].[Reference No]

The result is: 1-2-15-20003

but what I need is

WSD-HelpDesk-15-20003

Can you please assist me on this.

Thank you.

Trident

[cyanidem]

What you need is:
[CompaniesTable].[CoName] &"-"& [SectionsTable].[SctnName] &"-"& [MainTable].[Year] &"-"& [MainTable].[Reference No]

[trident]

Thanks Cyanidem, it works.