In my Access 2016 DB, I have 2 tables.
Table Customers has an Account Number field. It is Primary Key, Long Integer, Increment, Format "CN1"000. When I enter customers into the table, this field is autogenerating CN1001, CN1002, etc. This is as desired.
Table Customer Orders has a...