Hi Stauart.
I do this uisng an IIF seek to the other table, as a Couln in the grid
e.g. iif(seek(CustomerNo,'MyLookupTableAlias','MyLokupTableTag'),MyLookupTableAlias.Name,' ')

You must have the other table already selected to be able to use the Alias
Regards,
Gerard



>I have a grid I am using to capture date in. The first four columns in the grid are bound to the table. I want the fith column not to be bound to any column in the table. Instead I want to populate it with a value based on one of the bound columns.
>
>For example:
>
>CustomerNo
>Reg No
>Make
>Color
>Name
>
>The column name is not part of the fields in the table the grid is based on. I want to use the customerNo to look up the name and place the name value in the textbox of column1. I want this to automatically be updated when the CustomerNo in the grid has a value.
>
>Is this possible or will I have to make name part of the table?
>
>Thanks in advance