Insert record between two existing records

[hartmut]

 

 

I have a list of people in my records that have a chronological order but there are times when I and the user will need to insert a new record at the right location in the file. (Between two existing records) Is there any way to do this with a calculation or script? I guess I am trying to build a timeline that constantly needs this kind of insertion. Is this at all possible with filemaker? 

 

 

[Ocean West]

create an "sortOrder" field and enter 1, 2, 3 etc. if you need someone in between just put 2.5 - (always sort by this field )

if you wan't to "cleanup" just sort the field and do a replace starting with 1. 

 

the ONLY other method to have FMP have record in a natural chronological order is to import them already sorted.

[Lee Smith]

To add to what Stephan said, I would make sure that this number isn't tied to related data, i.e. as part of a key.