GUNS --> (linking table) --> AMMO

(A1.gun)                            (Aa1.ammo)

 

ORDER -->  GUNS

(fields...)     (B1.gun)
                   AMMO

                   (B2.ammo)

                   Table B3

                   (B3......)

 

I have put in bold the tables/fields I need to link.  IMPORTANT: GUNS and ORDER are two separate databases being pulled into one report.  So it is not allowing me to do a SQL statement.

 

GUNS (A1.gun) links to GUNS (field B1.gun) where A1.gun = B1.gun

AMMO (Aa1.ammo) links to AMMO (B2.ammo) where Aa1.ammo = B2.ammo

 

The idea is, I WANT TO SEE ALL "GUNS" and all "AMMO" even if there are none in "ORDERS".

 

At this point, all is fine and dandy when I set up my groups in Crystal Reports like so:

 

Group 1: A1.gun

   Group 2: Aa1.ammo

        DETAILS: B1.gun (although here I get zillions of duplicates)

                       B2.ammo (this one does not create duplicates)

 

This all works (despite the duplicates), but if I try to do this:

 

        DETAILS: ORDER (any field)

                       (B3.anyfield)

 

I get "Unknown Database Connection Error".  I have tried changing the join types with no success.  I am too much of a newbie to conceive of why my database links are making this report impossible.

 

Any help GREATLY appreciated!  This is for an immensely important report for my organization.