>>>Hello,
>>>
>>>We are using Visual FoxPro 5.0
>>>We are making a framework en we have a question
>>>about the security form.
>>>
>>>We want to use a grid and it must contain data from
>>>different tables.
>>>At the moment we are using a view, but we prefer
>>>not to use it. Is it possible to use a grid with
>>>data from different tables without using a view?
>>>
>>Afier,
>>
>>I feel you plan to leave a good approach for something worse. What are your reasons exactly?
>>
>
>We think that we could have problems in the future with views because of reasons such as renaming datafields in tables. Tables will always work, so we prefer tables instead of views.
>
>Greetings,
>
>Afier Appelman
>Using the account of Koos Veel

Afier, I agree with Jose about views, however if you are not planning to update the fields from the secondary tables then you CAN do this by first setting relations to the secondary tables and then using their fields in the controlsource for the column.

Again, if you aren't planning to use the grid data for lookups you can use a cursor, combining your data from different tables as you do in a view.

Think MANY TIMES before doing this, however. It may cause additional problems!

Barbara