General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
>I suggest you give a more specific example of what you want to achieve. What sort of information do the 6 "other" tables contain?
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.
Kev
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only