Bit of a strange one. I run an import from an external source which gives me around 260-270 records.

i am always only interested in the first 40 records.

The import is scripted. Is there an easy way to add into the script a command to delete every record after the 40th record? I am not quite sure how I would go about this other than going to the 41st record, delete record, and looping.

Is there a way to omit all records after 40 then show omitted, delete all ??

Thanks

Ed

How about:

Show all records

Go to Record [ First]

Omit Multiple [40]

If [ Get ( FoundCount ) ]

Delete All Records

End If

Omit Multiple... New one for me but works great thanks!

What is the reason for IF(Get (foundcount)) in the script?

If there are only 30 records for example, there will no found set, so no point in trying to delete.

Does the sort order matter? I mean, which 40 to keep is determined by creation order?

I just assumed because the OP said first 40 records in each table.

Well, you know what Felix would say...