BAQ SubQuery help

Kinetic ERP
1

I have a BAQ to get Quote Entry data

{1AD6B068-CBE7-4C03-BCA7-59F9F9E2537B}
{1AD6B068-CBE7-4C03-BCA7-59F9F9E2537B}809×539 30.2 KB

It pulls data for all quotes over $10,000.00.

What I am spectacularly failing at is adding the QuoteCnt table to the BAQ and having it pull data back even if the name and/or phone number are empty in QuoteCnt for the QuoteNumber. I want to get the Customer Name and Customer Phone number whether it is populated or blank for that quote number.

The issue is that it ONLY pulls data back if the user populated this data in Quote Entry.

2

You should just be able to turn your inner join into a left (or right) join.

Change your join type:

image

You want ALL rows from QuoteDtl, not just the matching rows.

5 Likes
3

Was just working on one of these today.
As @hackaphreaka Garret said Change the link to All rows from QuoteHead

image
image817×559 34.2 KB

4

That did it. Thanks!