Primary Key and foreign Key

[1aae]

Thank you
Should Name Foreign key = Name of Primary Key..
example OrderID Primary = OrderID foreign If Yes (Why)
should Foreign key = Autonumber data type (like primary key) (IF Not)
Using typing to Fill Foreign Key in the table (is this true)
thank you

 

[Nikos Yannacopoulos]

PK and FK do not need to share the same name as far as Access is concerned.
If the PK is autonumber, then the related field in another table (FK) cannot
be an autonumber as well, as (a) it receives the other table's PK values
rather than generating its own, and (b) chances are it's a one-to-many
relationship anyway, so you'll have multiple occurrences of the PK, which an
autonumber field does not accept.

HTH,
Nikos