Autonumber as a primary key

[fluidpowerchicky]

I am so totally stuck. Using autonumber as a primary key how do I create a relation to other tables? Do I make a field with type "Number" and an integer and just assume that the number will have to be typed?

X-)

 

[tempclerk]

I believe it says in table design that to match up with an autonumber your foreign key field has to be long integer. Having the number typed into the field would work, but there are many ways to automate that, in forms with lookups, etc. Best answer depends on what you are trying to do.

 

[THoey]

I would make it either the number or long int as tempclerk suggests. I would not allow the user to type it, as this gives the chance for a typo. I would have that field = your autonumber field's value. Terry M. Hoey

 

[Smack]

I set mine like:
Master_T ID is autonumber (Many)
Subtable_T id is long integer (Number) (One)
This will allow you to set a one to many relationship. You don't have to enter any numbers into the subtable, Access does it for you.
-Smack X-)

 

[Smack]

My bad. I walked off and realized I stated that backwards. The way I put would represent a Many to one, not a one to many. Srry for any confusion.
-Smack