First off, let me just say that today is my birthday, and I finally bought myself a Premier Membership subscription after three years.

Anyway...

I have a grid that I want to display line items for a purchase order. The data for column1 is the part_number and column2 is the description of the part which is found by a relation into the master parts table based on the part number. Very routine so far. The only problem is... I need to display descriptions from one table if the part number begins with a "1" and from another table if the part number begins with a "2". I have the relations in place for this, and tried to use:

grid.DynamicCurrentControl=iif(part_num="1", "text1", "text2")

where...
text1.controlsource=Table1.Descrip and
text2.controlsource=Table2.Descrip

Everything works fine as long as all the items for the PO point to only one of the two master tables. But if the grid contains some "1-xxx" and some "2-xxx", then it seems only to look for a match in the only the one table that goes along with the first line item.