General information
Title:
Database Relationship Problem
Hi all,
I have encountered a strange problem creating a report based on the following table definitions and relationships:
Customer Table -> Order Table -> Order Item Table
If I generate a simple report with three fields (one from each table) I get different results depending on the order they are printed on the report:
(Field) Customer Table, (Field) Order Table, (Field) Order Item Table
The above order generates the error message "No records matching your report criteria were found."
If I change the order to the following it will work:
(Field) Order Table, (Field) Customer Table, (Field) Order Item Table
All table relations have been defined in the database.
Has anyone had sonething similar ?
Thanks in advance,
Aaron Young
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only