Over the weekend, as I stewed about this issue, I wondered if it would be better to start with the main table being the Task table and go out from there with the Quote table. Would this make this query any easier?
--- In vantage@yahoogroups.com, "Emily" <emverbeke@...> wrote:
>
> I'd like to be able to tweak my current quote report to include the current active task for a quote as well as the person who is assigned to complete the task. I know the task table can be quite tricky to work with since it can be related to quotes, engineering projects, etc. With the query I have now I'm not getting extra lines of data (like I usually do when working with the task table) but I can't get it to display who the task is currently assigned to as well as really any task specific data.
>
> for each QuoteHed no-lock where QuoteHed.EntryDate >= 08/26/2011 , each QuoteDtl no-lock where (QuoteHed.Company = QuoteDtl.Company and QuoteHed.QuoteNum = QuoteDtl.QuoteNum ) , each Customer no-lock , each Part no-lock , each QuoteCnt no-lock , each Task no-lock where (QuoteHed.Company = Customer.Company and QuoteHed.CustNum = Customer.CustNum ) outer-join where (QuoteDtl.Company = Part.Company and QuoteDtl.PartNum = Part.PartNum ) outer-join where (QuoteHed.Company = QuoteCnt.Company and QuoteHed.QuoteNum = QuoteCnt.QuoteNum ) outer-join where (QuoteHed.Company = Task.Company and QuoteHed.QuoteNum = Task.RelatedToFile ).
>
> Any ideas? Thank you in advance.
>
> Emily
>