Reports relationships

[nashr1928]

Hello. I could really use some help on this. I have created a new report based on a query that I made for each customer. I have a field that is labeled Equipment Name and it gets its info from a table called status ID. On that tabe the left column is the ID #s and the right column is the equipment name. The proble is that in this field I only see the ID # insead of the Status column which shows the Name. Im getting confused. Can you help?

[nashr1928]

I have looked at this and decided because the 2 different tables have their own set of ID numbers it will not work the way I want. I will have to somehow merge the 2 together. Alot of work.