Compare fields from two tables

[mark12010]

Good morning:
I have a database with 2 tables (OCT_ASSETS and ALL_ASSETS)
Each table has asset # (ASSET_OCT and ASSET_ALL)
I want to compare the two tables something like this:
If ASSET_OCT = ASSET_ALL
Then I want it to show ASSET_OCT along with other data from the OCT_ASSETS table.

Thanks in advance Mark

 

[Charliy]

Sounds like all you need to do is link the tables in the Database Expert by dragging a line from Asset_Oct in the first table to Asset_All in the second table.