Add a line in repeating fields

[Edward Newman]

I am using a repeating field with 200 lines to comprise the body of a proposal. In this case FM is replacing what was previously done in Excel. Here is my dilema. As in excel, I need to be able to "add" a line in the middle. Oops I forgot to sell the customer 4 widgets, and that should go between the dingbats and thingamabobs. The only choice I have right now is to copy and paste of write a whole lota scripts to make a move up or down button. This seems so simple. Any insight???

------------------

Edward Newman, MCSE

Senior Manager

Universal Security Systems, Inc.

[danjacoby]

Replace the repeating field with a relationship/portal -- that way, you can add lines ad nauseum.

You can also set the relationship to sort based on, well, anything you like. That way, when you add lines to the portal, everything will reorder in whatever sort order you specified.

HTH,

Dan