>>Hello,
>>
>>I am using Visual FoxPro 6.0. I have a form with a grid on it. The RecordSource of the grid is a table called 'pending'. In that table there are two fields with numbers as values. Those numbers are related with a table called 'bedrijf'. The releation is set in the DataEnvironment of the form. In the 'bedrijf'-table there is a description of the number.
>>
>>Now I want to show the descriptions from the values in the 'pending'-table in the grid. With the relation that is working fine for the first value. The problem is that the second field in the grid is showing the same information as the first one. The value of the second field in the table is not the same. Is there a way to show the right description?
>
>Let me see; if I understand you right, you should open the BEDRIJF table twice (say, with aliases FIRST and SECOND) and set
two relations from the PENDING table into them.
>
>However!! In my experience, grids do not work correctly when you set relations to two tables or more, so my advice wouldn't work! I would then suggest opening BEDRIJF twice (as above), and set the ControlSource of the columns to
IIF(SEEK(firstvalue,"FIRST"), FIRST.something, "")
and
IIF(SEEK(secondvalue,"SECOND"), SECOND.something, "")
>HTH!
Thank you very much for your answer. It is realy working now and I only have to open 'bedrijf' once!
Greetings,
Afier Appelman