I am trying to create a report that combines 4 tables from a single database. This database can be either MS Access or MS SQL Server. I chose the Active Data Driver in an attempt to have only one version of the report that I can use against either type of database. The report will be viewed in both a VB application as well as an ASP project.
The tables are related as follows:
{General Information} - Unlinked, fields are displayed in the page header only.
{Header Information} - One to one relationship with {System Equipment}.
{System Equipment} - One to many relationship with {System Data} and one to many relationship with {System Range}.
{System Data} - Many to one relationship with {System Equipment}.
{System Range} - Many to one relationship with {System Equipment}.
I originally had created a report with the DAO driver for Access only and the three system tables were linked by an ID field that exists in all three (There was a second ID field that linked {System Equipment} to {Header Information}). One pointer from {System Equipment} to {System Data}, and one pointer from {System Equipment} to {System Range}. This report worked great. I have failed so far trying to duplicate this relationship as a SQL query string.
Does anyone have a suggestion?
The tables are related as follows:
{General Information} - Unlinked, fields are displayed in the page header only.
{Header Information} - One to one relationship with {System Equipment}.
{System Equipment} - One to many relationship with {System Data} and one to many relationship with {System Range}.
{System Data} - Many to one relationship with {System Equipment}.
{System Range} - Many to one relationship with {System Equipment}.
I originally had created a report with the DAO driver for Access only and the three system tables were linked by an ID field that exists in all three (There was a second ID field that linked {System Equipment} to {Header Information}). One pointer from {System Equipment} to {System Data}, and one pointer from {System Equipment} to {System Range}. This report worked great. I have failed so far trying to duplicate this relationship as a SQL query string.
Does anyone have a suggestion?