Hi Phil,
>I am trying to design an report that uses informtion from three tables (calibration master, calibration details and calibration companies). I tried the obvious approach and added all three tables to the dataenvironment, and the persistent relationships (as defined in the dbc) were showing. But when I preview the report, I am unsuccessful in making all three tables move together.
This is how its usually done:
1. Create a temporary Cursor like this:
SELECT Master.pk, Child.fk ;
from master left join child on master.pk = child.fk ;
into cursor 'temp'
Obviously this will need to be modified and more complicated, but its the thoery here.
2. Create your report with expressions PK and FK (no aliases) and remove all the tables from your DE.
3. Select your cursor and run the report.
Will this help?