Autonumber

[EMILYTAN via AccessMonster.com]

I have a field which is a primary key field in that table.
In another table, I set this field as autonumber but it disallow me to do
that because I have primary key field to be set with data type autonumber...
So, what should I do? I want it to be update cascade and delete cascade that
is why the data type has to be the same...

 

[B. Edwards]

Make the Primary Key an autonumber
Make the Foreign Key a Long Integer

 

[EMILYTAN via AccessMonster.com]

But my autonumber is a combination of text... If long integer also cannot
combine text right?

Make the Primary Key an autonumber
Make the Foreign Key a Long Integer

I have a field which is a primary key field in that table.
In another table, I set this field as autonumber but it disallow me to do

[quoted text clipped - 3 lines]

that
is why the data type has to be the same...

 

[EMILYTAN via AccessMonster.com]

Thanks...can use already...

But my autonumber is a combination of text... If long integer also cannot
combine text right?

Make the Primary Key an autonumber
Make the Foreign Key a Long Integer

[quoted text clipped - 4 lines]