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