Auto Number

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Long Integer field size 11
consolidate tables with make table query? 5
Avoiding Duplicate Entries 4
Primary Key Cascade Question 5
assign a unique identifier 3
query issue 5
put auto number in another table 1
Primary Key Autonumber - Is it the best choice for discrete ID num 11

Top