No query results, relationship issue?

[acrowe97]

I have 3 tables, all linked together by each other. The Tenant table is connected to the Lease table in a one-to-many relationship, and the Lease table has a one-to-many relationship with the Suites table. When I try to create a query to base a Form off of, no results show. Any help?

[JoeM]

Please post the SQL code of your query so that we can see it (switch to SQL View and copy and post the code here).
Also post some sample data from all three tables that includes data that would be found in all three tables.
Alternatively, you can attach a copy of your database here, and someone may be able to download and analyze it.