>>I have the remote view
>>
>>SELECT Pftenants.tn_key, Pftenants.tn_pfkey, Pftenants.tn_tekey,;
>> Pftenants.tn_tenantname, Pftenants.tn_leaseterm,;
>> Pftenants.tn_leaseexpiry, Pftenants.tn_area, Pftenants.tn_percrent,;
>> Pftenrent.tr_rate, Pftenants.tn_spacetype,Pftenants.tn_dateentered,;
>> Pftenrent.tr_startdate, Pftenants.tn_vacant;
>> FROM dbo.PFTENANTS Pftenants, dbo.PFTENRENT Pftenrent;
>> WHERE Pftenants.tn_key = Pftenrent.tr_tnkey;
>> AND Pftenants.tn_pfkey = ?rv_pf.pf_key;
>> ORDER BY Pftenants.tn_tenantname, ;
>> Pftenrent.tr_startdate DESC
>>
>>which after the join gives me several records for the same tenant with different rates. I need just first record of them. How I can get rid of others in one view definition?
>
>If I understand what your asking I think I can help.
>
>Below is a view in which the GROUP BY option for the SELECT command is used to Group the results by a unique ID, which means that they are only listed once in the result set.
>
>SELECT Hours.cgroupid, Active.cproject, Active.caccount,;
> Active.cactivity, Hours.ddate, SUM(Hours.ntime), Hours.chourid;
> FROM projmain!hours INNER JOIN projmain!active ;
> ON Hours.cgroupid = Active.cgroupid;
> WHERE Hours.cempid = ?cPassID;
> GROUP BY Hours.cgroupid
>
>If you plan on changing data in the result set and sending the changes back to the server, I am not sure if my suggestion will help you.
>
>Jeff

Thanks Jeff, I got the idea and tried it, but in client-server environment when I try to save the view it gives me "connectivity error" and asks one-by one for all other fields in the view to be included in GROUP BY condition. Didn't figure out why yet...