Need a function or code or expression that will generate a username value for that will not conflict with any username value that already exists in Table_MASTER. If the value already exists, then increment the generated value by a number (consecutively) until no conflict.
Example:
Table_MASTER, username field has values: John, John1, John2, John3
TableCalculated, username field has value: john
TableCalculated, NEWusername field = FUNCTION ?? This function would ideally generate the value "John4" since it will not conflict with any existing values in Table_Master, and is the next available number to use after John3.
Example:
Table_MASTER, username field has values: John, John1, John2, John3
TableCalculated, username field has value: john
TableCalculated, NEWusername field = FUNCTION ?? This function would ideally generate the value "John4" since it will not conflict with any existing values in Table_Master, and is the next available number to use after John3.