Primary Key Limitations

[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?

 

[Jeff Boyce]

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

 

[John W. Vinson]

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?

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.

 

[Darcy Highton]

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

 

[Noëlla Gabriël]

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