I have a UDO that contains a user field "member number" that needs to be unique and incremental. What is the best way to generate a unique number and make sure it is not duplicated?
I'm currently thinking of creating a user defined table and using the value of Code for this series.
This UDT will have a field named guid, and whenever I need to generate a member number I add a new record in this table with a newly generated GUID. And then search for the record with this GUID and return the Code.
Is there a better way of achieving this result, that I'm not aware of?