Order Line to Job Link

Yahoo Archive
1
You need to link the orderrel table to jobprod (job prod is the table which
'links' the order tables to the job tables). From job prod you can get the
job#. But, if you want more job info, you would then link to jobhead or
other tables as needed to get the info you want.

If you have orders without jobs you should do a left outer join to the job
prod table so you would see those with and without jobs.
2
I'm writing a report to display all open orders, line numbers, description etc., I also want to display the linked job numbers to the order line but I have not been able to find a way to do it. Can anyone give me some direction on that?

Thank you,
Abe Klassen

[Non-text portions of this message have been removed]