How can I move or copy the first 100 records to a new database file?

You could create a calculated field whose value is Status(currentrecordid) then perform a find on values 1...100 and export. This may not get you 100 records since you may have deleted one of those records at some point ie. 1,2,4,5,6,9,10...

Someone else may have a more sure way of getting 100 of the first records.

quote:

---

Originally posted by George:

You could create a calculated field whose value is Status(currentrecordid) then perform a find on values 1...100 and export. This may not get you 100 records since you may have deleted one of those records at some point ie. 1,2,4,5,6,9,10...

Someone else may have a more sure way of getting 100 of the first records.

---

Thank you for the information. A related question - Is there a way using RANDOM to generate a unique integer value for each record in a DB of 1000 records?

In version 5 there is an option on the auto-enter tab of define fields where you can do this.