>1) Create a cursor that have highest dates first for each
>group of field1:
>select * from Table1 order by field1,date1 desc into cursor xxx
>
>2) Create an old unique index (ok i know this is a cheap trick :))
>index on field1 to xxx unique

Or, I can use step 1 and SELECT from that cursor in step 2.