I am making a database and I want to make a field to generate it's own data on a table, similar to auto number. But I want it to it to be letters and numbers using the first 3 letters from another field.
For example
for company “ABC” the ID will be “ABC1”, and if there is already a company called “ABC”, then the second “ABC” company will be called “ABC2” and company “AAB” will be “AAB1”
The first 3 letters should be from the name of the company and the number is set it aside from other companies with the same first 3 letters.
Can anyone help me with this problem? :cry: