>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)