A much better idea will be to use a portal to a related table where "moving to the next line" is simply a case of adding a new related record to the portal. The same script might delete the oldest record from the top of the portal and add a new record to the bottom of the portal.
Thx for help, Have had problems in the past with repeating fields vs discrete records, so I understand it's a better way.
But dang …. I will have to learn some more things to do it that way, or pay somebody if i can't figure it out. Database structure has gone thru a big change last year and I'm not quite sure how to do that with the new structure. Plus I can't do it with a live database.
The reason I wanted to use the repeating fields is I would be done in 10 minutes….. (taking the easy way out.)
Is there no simple way to do it with repeating fields? If I can just do it with script steps and $variables I can do it on a live database.
Database structure has gone thru a big change last year
Ummm, but what I am describing is not new. It's basically the same structure and method that I would have used with FileMaker 3. Related tables of records and portals have been a standard part of FileMaker since then.
And it's just about as easy to set up as a repeating field--and much simpler as well as more flexible in the long run for this type of thing.