>I need to create a form that displays a list of records that are possible duplicates and give the user an opportunity to delete or change the records. The following SQL statements produces the recordset I'm looking for, but I'm having trouble presenting this to the user so the data can be edited. I created a form with a grid but I can't figure out how to have the grid display these records. Can I crate a local view through code for this?
>
>SELECT * FROM helthins WHERE helthins.ssno IN (SELECT ssno;
>FROM helthins;
>GROUP BY dedtype, ssno, sortkey;
>HAVING COUNT(*)>1);
>ORDER BY ssno;
>INTO CURSOR helthins_dupes
CREATE SQL VIEW ViewName as SELECT * ...
See VFP help for more on CREATE SQL VIEW
Mark McCasland
Midlothian, TX USA