I'm creating a database with 20 tables or so. I have come to the
table that will likely tie many of these tables together, that is
every single field in this table will be a foriegn key. My question
is, rather then include all of the fields into the primary key of this
table, and therefore include all of these fields into any table that
will reference this one, would it be politically correct to just give
each entry an integer as a primary key and scan for dupes in a
trigger? It sure seems like it would cut down on the complexity of
the whole thing...
Thanx in advance!