Autonumber

  • Thread starter Thread starter EMILYTAN via AccessMonster.com
  • Start date Start date
E

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...
 
But my autonumber is a combination of text... If long integer also cannot
combine text right?

B. Edwards said:
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
Click to expand...
[quoted text clipped - 3 lines]
that
is why the data type has to be the same...
Click to expand...
Click to expand...
 
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
Click to expand...
[quoted text clipped - 4 lines]
Click to expand...
 
Back
Top