Which data type for automatic number?

[=?iso-8859-1?Q?Ren=E9_Volkmer?=]

Hi, please help me somebody!
I have two tables. Table X and table Y. They are connected
thru the filed ID Y. ID Y is automatic nuber type. Which
type should have field ID Y in the table X? Thank you.
Sorry for my english:/
Have a nice day.
René Volkmer

 

['69 Camaro]

The Autonumber uses the Long data type.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.


Hi, please help me somebody!
I have two tables. Table X and table Y. They are connected
thru the filed ID Y. ID Y is automatic nuber type. Which
type should have field ID Y in the table X? Thank you.
Sorry for my english:/
Have a nice day.
René Volkmer

 

[Guest]

Hello,
Yes, choose the Long Integer Field size for Y_ID in both tables.
It is also even better not to use "space". Use Y_ID in place of Y ID.
You also have to check which type of relation you have between both tables
and to define it in the relationships.
Check also if the field is indexed.

Phil