How to insert a row in portal data?
Example : if a portal would look like
and one wants to insert "C", it would be nice to have it between "B" and "D" .
However, Filemaker will insert it after the "D", which is inconvenient.
(in this example sorting on name would work, but there are many other examples where it does not, where one wants a very specific, sometimes subjective, order of portal records).
Thought about adding a field "sort" and sort on that number, giving
but then the user needs to change the value of D from 03 to 04 and set C to 03 ... again, not very user friendly... (althought it would work)
So I'm looking for a clean and easy way to insert a row between two rows of a portal.