I am working on an application for an auto lot where they purchase vehicles wholesale and sell them retail. Many times there is work that must be done on the vehicles before they can be offered for sale. I have a table for the vehicle and one for the repairs that I have created a relationship for. Unfortunately, when I do a report for offering price, if there are no entries for the repairs then the report field comes out null. Why is this happening and how can I correct it?

The default join type is - INNER. An inner join returns only rows from tableA that have matching rows in tableB. Since you will not always have matching rows in tableB (Repairs), you will need to change the join type to - LEFT. A left join returns all rows from tableA and any matching rows from tableB.

To change the join type, right click on the center of the join line and choose the option that will return the correct set of rows.