With a little luck and some assistance, I discovered how to get the linking information out of Crystal Reports.
Go to Database > SQL Query. This shows you the SQL Query that CR creates in order to extract the data. It gives you the tables, joins, etc.
Example:
(("x3v5"."PILOT128"."SDELIVERY" "SDELIVERY" INNER JOIN "x3v5"."PILOT128"."BPCARRIER" "BPCARRIER" ON "SDELIVERY"."XLCCAR_0"="BPCARRIER"."BPTNUM_0") INNER JOIN "x3v5"."PILOT128"."XFRTSHPHIS" "XFRTSHPHIS" ON "SDELIVERY"."SOHNUM_0"="XFRTSHPHIS"."VCRNUM_0") INNER JOIN "x3v5"."PILOT128"."BPADDRESS" "BPADDRESS_ST" ON ("SDELIVERY"."BPCORD_0"="BPADDRESS_ST"."BPANUM_0") AND ("SDELIVERY"."BPAADD_0"="BPADDRESS_ST"."BPAADD_0")
This gives me the data I am looking for.
HTH,
Gilley Estes
IP Logged