I need to duplicate 100 records that that have 40 fields each. I'd like one field to keep it's current data and the rest of the fields to be empty.

Is this possible?

Edited July 27, 200520 yr by Guest

You could set 39 of the fields to auto-enter "", duplicate one record and clear the 39 fields and then duplicate the rest, or create a script to do it for you.

Where would I find example scripts? I want to learn FM scripting anyway?

I need to duplicate 100 records that that have 40 fields each. I'd like one field to keep it's current data and the rest of the fields to be empty.

Sorry for saying it, but it seems not to be particularly structured data sets we're talking about here???

My stab at your problem is almost opposite of JT's ...if the 40th field is an autoenter "Value from last visited record" could it be done like this:

Go To Layout x

Show All Records

Go To Record Last

New record

--sd