I was wondering if anyone has a solution to the following problem. I
have a few tables similar to the following.
person_table
city_table
company_table
If I want to associate a person with a one or more cities. I need to
create a city_persons table that contains just the primary keys of both
the city_table and person_table. If I want to associate a person to
many companies, I have to do a similar thing. Now, if I wan to
generalize these associaes I can create something like an associate
table which will contain both id's plus two columns which indicate the
source and target tables of the relaionship. Does anyone have
suggestions along these lines on how to generalize such relationships?
thanks,
--eric