>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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."