about referential integrity in ACCESS

[sohelcsc]

hi,
i am facing a problem with referential integrity in ACCESS that is suppose i have a primary key which datatype is autonumber and that primary key is using as a foreign key of another table but i can't use autonumber in that foreign key. that means datatypes are different for different table for the same field. in this situation if i want to create relationship in that case i can't enforce referential integrity. an error message is shown that is : you can't create referential integrity for the different datatypes.
so in that case how can i apply referential integrity to my database?

thanks
sohel

 

[raskew]

What datatype is your foreign key? To correspond to an autonumber, it should be setup as a long integer. Look at the relationships in Northwind to see numerous examples.

 

[sohelcsc]

thanks a lot.
now its working well with your idea.

thanks again
sohel