duplication of record a specified number of times

[Twe]

I need to automate the duplication of a record a fixed number of times, advancing the unique ID number only each time. The context for this is the recording of multiple copies of the same book title/object within an inventory.

[Balder]

maybe this helps:

Create a script like this if you want 5 copies

(Counter = global field, number)

set field (counter, 0)

do

set field ( counter ; counter + 1)

exit loop if counter = 6

duplicate record

set field ( ID ; ID + 1)

loop

This may not be the correct syntax but probably you understand...

[Balder]

Sorry,

do

...

loop should be

loop

...

endloop

[Lee Smith]

Please update your profile to reflect your Platform, Operating System, and version of FileMaker you are using. The link is in the box where your name appears on the left and is the word "profile" that is in blue.

Lee