What happens if you create an index on the child view in the load event of the form and then set the relationship there? If I remember correctly, the DE is loaded already. If not, then try to load the views in the load event of the form instead of the DE and create the index and set the relationship. Let me know if it works. I'm curious!

Tracy

>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