How to display data for two different fields that pull data from the same table.

[dibar]

I am working with an incident management database. I have a table that holds all the ITEM information. I have two tables that hold the data from incidents logged into the system, INCIDENT table and INC_DATA table. On the incident logging form there is a field for ITEM A and another field for ITEM B, among many other fields. Both of these ITEM fields are populated with data from the ITEM table.

What I am trying to do is create a report that will show me the ticket number, logged date, user name, ITEM A and ITEM B. ITEM A and ITEM B come from the same table causing a great deal of confusion for me.

I have a report that will show me ITEM A (ITEM.ITEM_N)
INCIDENT.ITEM_ID linked to ITEM.ITEM_ID

I have another report that will show me ITEM B (ITEM.ITEM_N)
INC_DATA.ITEM_B_ID linked to ITEM.ITEM_ID

How can I get both ITEM A and ITEM B in the same report.

Fairly new to Crystal reports, beginner level.

Thank you
Bill

 

[Madawc]

If you add the same table twice, the second time it comes as an "Alias" and is treated as if it were a distinct table.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[dibar]

Thanks!

I should have posted this question a long time ago. I spent hours trying to figure it out. Can't believe it was that easy.

Your assistance is greatly appreciated.

Cheers