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.
