Serialize by category

[dysong3]

Hi,

I need to create different serial numbers within the same file that are defined by category and that remain hard serial numbers (that is they never change). eg. Eggs1, Eggs2, Bacon1, Bacon2, etc. The solutions I found here seem to be soft, that is they change depending what the found set of records is. Could anyone give me a pointer to a solution for this? I'm sure it's simple, but my simple mind sometimes gets overwrought.

[comment]

It might be simple, but it's very difficult to make it reliable. Why do you need this, instead of Eggs1, Eggs2, Bacon3, Bacon4, etc.?

[dysong3]

I think I may not have expressed myself as clearly as I should have. Eggs1, Eggs2 is an exemple of the serial numbers that I would like to automatically generate for all records in the file that are in the category "Eggs". (Obviously it's probably a concatenated field of category "Eggs" and the serial number by category that I imagine needs a relationship). All of my records without exception would be in one of the given categories. Is that clearer?

[comment]

That's what I understood in the first place.