>>>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.
>
>1) That will never happen.
>2) Type+Ref, not too bad
Let me reformulate. Of course, you know your proposed table structure better than I do. Now, do you see an easy way to create a query/view that combines the seven tables? 'Cause that was the trouble I saw, a while ago, when trying to create "alternative relations".
>Quite simply, the table is a list of people, and there will need to be the ability to create lists related to different tables, so there will be more than 6 tables in the long run.
Meseems the 6 "other" tables should go into one single table, with a field indicating the type. But again, you know the proposed structure better than I do, so I might reconsider after getting more information.
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)