>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.





Put iif(part_num="1",Table1.Descrip,Table2.Descrip) as column2.controlsource propertie.

Joco