Ok, it's simple, but it's one of those things that you can easily get trapped by. I've been trying to find a neat solution to this, but so far, I have not found it.
I have a parent record with a portal showing children records.
I wish to be able to number the child record in relation to the parent:
eg: a contact may have multiple addresses in the portal,
each address will have the numbering:
which is simple enough, however, the records can be created via the portal AND deleted via the portal.
With creation, I wish to have the next highest number automatically put on the record.
With deletion, I don't want the preceeding numbers to change, they should remain the same.
eg: Deleting number 3 should allow the next address entered to be 3. Deleting number 2 will mean the next number is 4.
There is a problem with timing when creating more than one related address at a time (record commit)
Is there a simple way to make this happen?
remember, address 1,2 and 3 could all be created via the portal at the same time.