>I have a Grid in which I want to diplay two fields,a Code field and a description field, which come from 2 different tables:
>
>Field 1 Control Source: Filea.Code
>Field 2 Control Source: IIf(Seek(Filea.Code,'FILEB'),Fileb.Descr,' ')

Relate view Fileb to view Filea at the init event of the form just after creating index required.

Select Fileb
Index On code Tag Code
Set Order To Code

Select Filea
Set Relation To Code Into Fileb Additive

Grid's recordsource should be Filea. Field 2 controlsource would be Fileb.Descr without IIF() expression
>
>However, as soon as I include the seconf field, the whole grid blanks out.These tables are quite large, so I would prefer not to use a View if at all possible.
>
>Regards,
>Gerard