Using a number in one field to create new records

[leomark]

I'm working on a movie database.

I have a field that tracks number of certain scene types in a feature. Let's say "10". I want a button that can create the same amount of "New Records" in a related table that breaks those scenes down into details.

I haven't found anything in New Record that can be modified.

Any ideas?

Thanks!

[Fitch]

The button will need to perform a script, e.g.:

Set Field( gCounter ; SceneTypes )

Go to layout( scene details )

Loop

  Exit Loop If ( gCounter = 0 )

  New Record

  Set Field( gCounter ; gCounter - 1 )

End Loop

Go to layout( original layout )

Note: gCounter is a global field; in FileMaker 8 and newer, I'd use a variable instead.

[leomark]

Got it!

Thank you guru master!