We have 6 customer price lists. We would like to be able to see all the prices for one part on one grid. I made a BAQ that looks like this:
So far so good. I used a separate subquery for each price list column. (Linked the same PriceLstParts five more times, each with a different price ListCode as the criteria).
Now, we would like to make this grid Updateable. I can get the price from the primary query to update, but not the subqueries.
Is there some fundamental limitation on UBAQ that precludes using subqueries?
If so, is there another way to create a BAQ that doesn’t require subqueries? The PriceLstParts table has one line for each PartNum / ListCode combination.
Another approach all together?
Thanks for any ideas.