Hi,

I need to create Job reports for clients.  In any of the transaction tables, there is no reference to Jobtype fields at all.  My understanding is that a customer can have multiple jobs.  Where is the link between customer and their multiple jobs.

Thanks for your help.

Siva

The actual Job Reports can be called directly in QODBC using stored procedures. See: How do I use the QuickBooks Reporting Engine with QODBC? I've heard something about sp_report ? 

Every job itself is a customer record with the parent customer record linked in the ParentRefListID itself like this:

SELECT ListID, FullName, ParentRefListID FROM Customer where FullName Like 'Abercrombie, Kristy%'

See also: How do I access data in the standard QuickBooks report Time by Job Data for more flexible reporting?