Creating Job/order summary report

[lpkorn423]

EDIT: SOLVED!



I have a database that is very similar to this data model:

http://www.databaseanswers.org/data_...ices/index.htm

I'm looking to print summary reports by Job (equivalent to an order). Each Job/order has multiple lines that can be invoiced separately. I've included a pdf of my relationships in case there is an issue there. Currently I am using a query that has criteria on the JobNumber (JobID) to match the JobNumber text in the corresponding form. This worked out for me when I was trying to print invoices, but while trying to use the same method for JobNumber, it seems to populate by invoice. For example, if there hasn't been an invoice created for a JobNumber, it doesn't populate any of the JobLines in the report.

I'm thinking there is an issue in my relationships. Any suggestions?