>Hi
>
>If you had a table that was related to say, 6 tables, would it be better to have 6 individual foreign key fields, or would it be better to have 1 foreign key field and then a "type" to identify where it came from.
>
>I prefer the latter, but what about everyone else?
>
>Thanks
>Kev
I see two difficulties with the approach you propose: 1) What if the table is related to two or more other tables at the same time? 2) It is quite messy to define relations.
I suggest you give a more specific example of what you want to achieve. What sort of information do the 6 "other" tables contain?
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)