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, 200916 yr by Guest

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

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.