TaliesinAC
Programmer
I am currently working on a report that displays data from two tables. The "Parent" table is an ADO recordset passed into a Crystal 8 report. I would like to link the "child" table (different database) to the "Parent" utilizing Active Data also (ADO one-to-one ADO). The linking is simply a string in the "Parent" table linked to a unique string in the child table to display both the code and description of the code in the report ("Parent" stores the actual code, "child" stores information about the code"
. If I use ODBC and just link the "child" table to the ADO recordset ("Parent" everything is fine. But, when I link the "child" ADO to the "Parent" ADO through the Visual Linking Expert (it does link correctly in the VLE), I wind up with a cartesian product. It's as if the link never occured.
Hope this makes sense.
. If I use ODBC and just link the "child" table to the ADO recordset ("Parent" everything is fine. But, when I link the "child" ADO to the "Parent" ADO through the Visual Linking Expert (it does link correctly in the VLE), I wind up with a cartesian product. It's as if the link never occured.Hope this makes sense.