Linking LaborDtl to JobHead in BAQ Designer

Include JobOpDtl and link LaborDtl to it on Job Num and Assembly Seq.
Linda

--- In vantage@yahoogroups.com, "subzerovi" <tmcmullen@...> wrote:
>
> I have a BAQ that shows Open Jobs and displays information from the LaborDtl table if labor has been recorded on the job. In order to get jobs to appear on the report that don't have labor information, I had to use an Outer Join to connect these 2 tables, but I am wondering how I can make that link stronger so the report doesn't cause performance issues.
>
> Does anyone have any suggestion on the best way to link these tables?
>
I have a BAQ that shows Open Jobs and displays information from the LaborDtl table if labor has been recorded on the job. In order to get jobs to appear on the report that don't have labor information, I had to use an Outer Join to connect these 2 tables, but I am wondering how I can make that link stronger so the report doesn't cause performance issues.

Does anyone have any suggestion on the best way to link these tables?