Child aware of order of appearance in parent table

[panchristo]

Hi all,

Im facing this little puzzle and I wonder if anyone can help.

I have a Cases table and a CaseIndividuals Table.

What I would like to do is when creating a child in the CaseIndividuals to automatically assign an arbitrary name (i.e. Individual_2) to the individual before completing FirstName, Lastname etc. (Name Fields may never be completed)

So far, the only solution I have found is to use a self join for CaseIndividuals in order to count the same CaseID occurences. Using that I can suffix the "Individual_" with the total number of records for the same case.

The problem however arises if I delete one of the individuals in the meantime and then create a new one. For example if I have Individuals 1-4 and delete No3, then when entering a new one it would be named "Individual_4", whereas I would like to be able to rename Individual_4 to Individual_3 (compensating for the previously deleted) and then add a new one. And all of that automatically :

Any ideas?

[comment]

This can be done by changing your self-join to include individuals with the same CaseID AND a smaller serial ID, and using an unstored calculation field for the count.

However, this means any deletion will instantly rename all "younger siblings" - so the question is whether you have any use for names that are not permanent.

[panchristo]

No, not any important use really apart from arbitrary naming inside a portal like "Individual_1", "Individual_2", etc.

I'll try your advice, thanks a lot.

[comment]

arbitrary naming inside a portal like "Individual_1", "Individual_2", etc.

This can be achieved by a much simpler method:

DynamicNumbering.zip

[panchristo]

Hahaa, indeed, but what I was really looking after was to have the same numbering on the children table , when viewing details.

Otherwise, the @@ symbol is what I use too.

Hence the title "children aware of order"