>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.
>
>The calibration details (many) are related to the cal. master by the tool number (one). The calibration companies are related to the cal. master by the two letter calibration co. code.
>
>I am able to create these relationships programatically in the command window and have the tables move properly in browse mode. But what is the secret to successfully opening these three tables in a private datasession for the report? Its gotta be something obvious, but I'm not finding anything like this in help, tastrade or solutions.
>
>TIA,

I bet that you are not on the primary table, but on a secondary one. In the DE's init try DODEFAULT() next line Select MY_Primary_Table.

Others have said to run SQL but what you are doing is fine.

__Stephen