 | |
#191
 
| |||
| |||
|
Re: Multiple tables refer to one -To use foreign keys or not? -
08-20-2008
, 07:12 PM
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#192
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#193
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#194
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#195
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#196
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#197
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#198
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
#199
| |||
| |||
|
|
Gene Wirchenko <ge... (AT) ocis (DOT) net> wrote: Bob has marked my postings to be ignored so he won't read my reply. As far as I know he is the only person who has ever kill filed me in the newsgroups. Judging by his other replies though I view his action as a badge of honour and worthy of distinction. Why how precious. Plonked. I've now been plonked by two people in this newsgroup. Whoohooo!! |
OP's question. Roy's and Adrian's responses were good pointers, while
the general warning away from EAV by everyone else was also apt. I'm
not sure how your personal anecdote contributed to his trying to
reference multiple relations from the same foreign key.
Quote:
|
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
attachments? Sure attachments are all of the same type but relations
don't collectivize objects (a common misconception that has to be
shaken off when moving from OO to RM). Relations collectivize
propositions of a common form - and yours seem to be different.
Regards, J.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.