Primary and Foreign Key differences between mdb and adp

We're new to Access and have sussed out that you use an auto number as a primary key and Long Integer for the foreign key but what are the equivalents in Access project?
Who is Participating?
Data-ManConnect With a Mentor COOCommented:
create a field of type int and set it to Identity = yes.

int in Sql server is the same as a long int.

don't use big int in sql server, there is no equivelent in Access.

All Courses

From novice to tech pro — start learning today.