Primary Key Limitations

  • Thread starter Thread starter Darcy Highton
  • Start date Start date
D

Darcy Highton

I thought I read somewhere that a PK can be used as a FK in only 2 tables. Is
this true, or is there any limit to the number of times a PK can be used as a
FK?
 
Darcy

I've never heard that before. I guess I didn't realize I couldn't do what
I've been doing. Not knowing is so liberating!

(no limitation I'm aware of -- any idea where you saw that?)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I thought I read somewhere that a PK can be used as a FK in only 2 tables. Is
this true, or is there any limit to the number of times a PK can be used as a
FK?
Click to expand...

No limit that I'm aware of. There is a limit of 32 indexes on a table, which
can be a problem if a table has more *foreign* key fields - but since in your
example, the table only needs one primary key there should be no issue.
 
Thanks Jeff,
I'm not sure where I had read it but, I'm sure I've seen the limitation
stated in more than one place (couldn't find it again though).

Thanks again for your reply... your answer will make design soooo much easier!

Darcy
 
Hi,

I have atually a database containing the table tblLanguages, and I used the
PK lanID there in more the 5 other tables as FK, never had any problems with
it
 
Back
Top