Formula to increment by 1 for multiple instances of relationship


#1

Hi all,

I am trying to work out the best way to increment an index for multiple instances of related fields.

In my table I have {Name} and {Sizes} as related fields.(Sizes allows multiple)

There may be more than one occurrence of {Name} as this table is being used to join {Names} with multiple size options.

I would like the unique record ID to look like this ItemName - 1 and should there be another Name because it has a further size it would look like this ItemName - 2. In the case of a SecondItemName, I would want to reset the counter to SecondItemName - 1.

That is were it looses me completely.

Any help appreciated.