Select Query Problem

[JasonSummers]

I have a table (cables) with fields - CableNo, System, TOequipment_cnt, FROMequipment_cnt. My (Equipment) table has fields Equipment_cnt, equipmentID and so on. I want to populate a a report With CableNo, System, and the equipment ID (from my Equipment table) equal to the ToEquipment_cnt AND the FROMequipment_cnt.


Example

CableNo = 1STC10.33
System = Main Steam
FromEquipment = Power Panel 123
ToEquipment = Motor #456

Basically I have a code for the equipment in one table and the actual equipment number (and the code) in another table. But since the number will show up twice in each record (To and From) I have problems linking

Thanks Jason

 

[Darrylles]

Hi,

What problems with 'linking'?

You seem to imply two fields (same value) will show.
You can in Query Builder - click the 'Show' check-box off for one of them so it isn't returned.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk