>Ooops. A little correction. There orders would cause headaches. Instead create a custom or form property that would return to_address :
>
>

*Form.GetLookup
>lparameters tcTable, tcKeyField, tcValue, tcLookup
>lparameters tcID
>select &tcLookup ;
> from (tcTable) ;
> where &tcKeyField = tcValue ;
> into array arrResult
>return iif(type('arrResult[1,1]')='C',arrResult[1,1],'')
>
>* Controlsource
>thisform.GetLookup('orders','order_id','order_id','to_address')
>

Cetin

Hi Cetin,

I implemented something similar to the above and it seems to be working. Thanks.