Have two tables - Table A and Table B.

Table A contains Customer Information - for example:

Cust   Doc#    Amount   Transaction Type      ShipToCode

ABCCO 12345   100.00    IN (Invoice)           1
ABCCO 23456   200.00    IN (Invoice)           2
ABCCO 2354     50.00    CN (Credit Note)       2

Table B contains the same information but has extra transactions pertaining to payments of the above invoices. So for example:

Cust    Doc#    Amount   Transaction Type

ABCCO   12345   100.00   IN
ABCCO   23456   200.00   IN
ABCCO   2354     50.00   CN
ABCCO   PY12345 100.00   CA

I want a report where I can connect the two tables to include all of the fields in table A and add just the "CA" transaction type for table B. But as soon as I try to mix the different tables the report goes blank.

I assume a linking issue of some sort but can't figure it out.

Thanks in advance for any input.

sorry for LATE response...join