Which data type for automatic number?

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

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.


"René Volkmer" wrote in message
...
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

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

"René Volkmer" wrote:

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