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,' ')

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