>>>1. When adding views to a data environment, is there any easy way to set a relation between views?
>>
>>Use List.Requery() to refresh list. I don't think it's practical to set relations between views but you can index view and use tags and SET RELATION to get it.
>
>Why don't you think it is practical to use relations between views? I have an application that previously used local tables, and I'm trying to upsize it to SQL Server. I have many forms that used multible tables. I thought I could just replace the tables with parametized remote views and set relations between the views. Is there any easier or better way to do this?
>
>Jeff
easier way is to do all the 'combining' when creating the views. otherwise, you'll need to build indexes for the views, etc.