Primary and secondary Keys

[DavidCantor]

I have two entities with aone to one relationship. Can I use 1 primary key for both tables? ie can the primary key in table a be the same (Store ID)as the primary key in table b (Store ID)? or do i need to define a unique primary key in each table

 

[AccessMSSQL]

Yes..but they can't both be autonumber fields.

 

[plog]

Just because I'm a normalization nut, what's the data in both Tables? Also, is one a sub-set of the other, or do they have the same number of records?

 

[DavidCantor]

one has product data and the other is the product label data