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