hello i have attached example
a form attached to table- (3) fields serial number/code number/ key number
users only have to enter code number ( other fields are already populated)
question- if i can explain-
the code numbers always start with (example) 100005 or 100006 or 100015, etc...
is there a way to have the 6-digit prenumber be added in every field automatically so user only has to enter last 6 digits which are always unique-
and then if after user enters 50 numbers and wants to change pre-digit number - is that possible.
real number is like this 100005abd456 or 100005789ad5-