My project uses mySQL, of course. There are several databases in the system, each has a members table that is identical to the ones in the others. Members are checked as active of non-active (money). Now, opposed to editing every members table in every database, I'd like to adopt the following approach: house the members table in a separate database, edit that and have the update "seep" through to the databases, a likley-like the "other" db server where you'd link tables between databases. I heard the term "confederated" tables
Any ideas where to get info, some howto and some examples?