Fields On Report

[Lois]

Hi
re request for use of despatch vehicle & driver report: is there any way i can get the fields from the customer list re the delivery address to appear on the report. when i run the request for use of despatch vehicle & driver query it wont run properly when i add in the fields on the customer list table...

[RuralGuy]

I'm going to start by *strongly* suggesting you use the same name for a field regardless of the table within which it resides. Your relationships are a bit confusing at this point.

[RuralGuy]

Your JobList table has 2 references to the Customer List table when only 1 is necessary. Once the relationship is established, all of the fields of both tables are available as if they are in one table.