I am working on a updatable baq. In one of the fields, I want it to display all the contacts for the customer on that line. The way I have done this is to create a drop down list which pulls its data from a BAQ.
Here is the BAQ for reference, it displays the invoice num from invoice header and name from CustCnt
When I try to update the field, it shows a drop down list all the contacts for every customer. What I want instead of the contacts of just the customer of that one line/record. Is there a way to do this?