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 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?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison