Query design hangup

[lpkorn423]

Quick overview of the table designs

TblJobs
-JobID
-fkCustomerID
-PO
-JobDate

TblJobLines


-JobLineID
-fkJobID
-PartID
-Qty
-PriceEach
-LineDescription

TblInvoice:
-InvoiceNumber
-InvoiceDate
-InvoiceTotal

TblInvoiceLines:
-InvoiceLineID
-fkJobLineID
-fkInvoiceNumber

TblCustomers:
-CustomerID
-Billing address etc...

TblParts:
-PartID
-PartDescription

I need a query that populates all JobLineID along with related data. This wouldn't be difficult except that not all JobLineID's are linked to an InvoiceLineID (and in turn an InvoiceNumber). Is there a way I can have a query populate ALL JobLineID's and it just leave the InvoiceLineID column (and InvoiceLineID specific data) blank if there is not a related record? I am attaching a PDF of my relationships if that helps.

The purpose of this query/report will be to keep track of what has been invoiced, what needs to be invoiced, and whether payment has been recieved or not.

[pbaldy]

Try editing the join between the tables in design view. You can right click or double click on the join line to edit, and the descriptions should be pretty helpful.

[lpkorn423]

Well that points me in the right direction thanks!

[pbaldy]

Happy to help!