N
News Boy
I have data in 3 tables called Carriers, Routes, and Subs. I can make a form
display data from one table at a time. But, to access multiple tables, a
query is necessary. I have created a query in Query Wizard which displays
the relationships between the tables, etc. In Design View, with the Query as
data source, the form displays all the field names of all the tables
properly. But the form will not access any of the records in the tables.
The help files suggest that the query may not be outputting any result, but
does not say what to do to fix this.
display data from one table at a time. But, to access multiple tables, a
query is necessary. I have created a query in Query Wizard which displays
the relationships between the tables, etc. In Design View, with the Query as
data source, the form displays all the field names of all the tables
properly. But the form will not access any of the records in the tables.
The help files suggest that the query may not be outputting any result, but
does not say what to do to fix this.