>Hello group,
>
>Still learning about forms for multiple tables. I have remote views to databases in SQL 7.O in VFP 6.0. I placed an unupdatable view called vheaders and an updatable table called vstufind that are related by the ident field. I tried everything I could think of to form a join or relationship between the two views but nothing happened. Is it possible to join two views in the dataenvironment window?
>
>Thanks
>Jim

I don't think so. I think this sort of relation requires a permanent index, and views don't have such a thing.

You can create a temporary index, and set the relation later.

Or you can use another solution - especially, using a parameterized view: the second table depends on a parameter from the first view. In this case, the data should not be initially loaded, but the p-view should be refreshed every time you move to another "parent" record.

HTH, Hilmar.