Insert a row between existing rows of a Portal

[Philippe Danks]

Hello everybody,

 

I am very new to FM and am exercising myself with the Estimates startup solution included in FM Pro 12.

 

So far, so good....except that I really wonder how I can insert a new row (not at the end, as default) but between existing rows of a portal.

 

Is there be a "simple" way of doing that in FM Pro 12 ?

If not, must I dive into coding by adding a Relative Record Number to each record, leaving "holes" between the RRN's and by coding a button "insert below" that would then find the RRN of the record I am positioned on and add 1 to the RRN to create the new record and insert it ?

If I need to code, could someone help with a practical example or explanation ?

Thanks a lot,

 

Philippe.

[LaRetta]

Hi Phillipe, welcome to FMForums :-)

The natural sort order of data in tables is creation order. If you want different order then you must sort when and where you need it. So since you want to change the order of records being displayed in the portal, sort the portal by those fields.