Creating multiple records @ one time

[Michelle Logan]

Hello again everyone.

We have a new question that none of our in-house people can figure out.

Is it possible to create 42 records at one time in numerical order in a list layout.

We have 42 seats in a split class and instead of creating a record for Seat 1 | Hannah Jones | Mrs. Wingfield.

We would like to create all 42 seats at one time

Seat 1

Seat 2

Seat 3

and then fill in the other data as the seats fill up.

Is this possible?

Thank you very much,

Michelle Logan

Edited October 9, 2009 by Guest

[Søren Dyhr]

Well there are several, here's an unortodox method:

http://www.fmforums.com/forum/showtopic.php?tid/211369/fromactivity/myposts/

...that needs some tinkering to suit your purpose!

Attached file shows another method...

But what you in actually needs to study is the relational structure of this:

http://fmforums.com/forum/showtopic.php?tid/176396/tp/1/

....since you otherwise might bark up the wrong tree?

--sd

split.zip

[comment]

I believe the simplest way to do this is to have a "bank" table with 42 records and import them every time you need a fresh set. Or you could have a script looping with a counter, creating new records until counter reaches 42.

Note that creating "placeholder" records is not the best practice - records should be created as needed. But creating records against a grid is not a simple task, so I'd say go with the import for now.