By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Relationship Question

P: n/a
I hava a table storing client info and the ClientID field is my PK.
The client can do many things: make donations that get stored in
donations table, make purchases that get stored in the purchases
table, receive up to 20 monthly periodicals which are stored in ...

Is it OK if I use the ClientID field from my Client table as a foreign
key in several other tables as a one-to-many relationship?

It just looks kind of strange.

Thanks

Joseph

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Yes, it is OK to have multiple relationships including the same table.

Larry Linson
Microsoft Access MVP

"arejay" <ar*******@yahoo.com> wrote in message
news:8v********************************@4ax.com...
I hava a table storing client info and the ClientID field is my PK.
The client can do many things: make donations that get stored in
donations table, make purchases that get stored in the purchases
table, receive up to 20 monthly periodicals which are stored in ...

Is it OK if I use the ClientID field from my Client table as a foreign
key in several other tables as a one-to-many relationship?

It just looks kind of strange.

Thanks

Joseph

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.