Auto Number

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

To display 7 digits for the autonumber make the format for
the field 0000000.

I don't know why you need to have the autonumbers the same
in both tables. Besides its too risky. Make the primary
key in the main table the foreign key in the secondary
table and use the subform approach.
-----Original Message-----
How do I get the auto number to display 7 digits? Also
Click to expand...
I'd like the auto number field to be the same number in
two different tables. The tables are supposed to link to
two different forms. Or should I make the small form a
subform of the larger one?
 
Right. Never use autonumber as a relationship key. Doing so immediately rules out the possibility of ever updating your data in the future and ensures that you can never recover via backup from failure.
 
Back
Top