Hi all,

How do I auto create new records based on a number in a field. i.e. If the field has a four in it then I want to create four new records?:

Looping?

yes. assuming you want to create related records such as line items to a parent record, something like

set variable [ $total ; table::number ]

set variable [ $parent ; table::ParentID ]

go to layout [ child ]

loop

 new record / request

 set field [ child::fkParentID ; $parent ]

 commit records / requests [ no dialog, skip validation ]

 set variable [ $total ; $total - 1 ]

 exit loop if [ $total < 1 ]

end loop

go to layout [ original ]

commit records / requests [ no dialog, skip validation ]

See:

http://www.fmforums.com/forum/showpost.php?post/283950/

good one. thanks.