i have redhat e. v2.1 mysql v. 3.23.54a-3.72, postfix 2.0.10, courier-1.7.3 and amavisd-new (newest version) and i'm successfully running mysql as the backend for both. My question is this:
all of the data for the above programs is all stored in a bunch of different tables. aliases_this, virtuals_that, vgid_another..etc... What i want to do, is create one table, for originalities sake lets call it "master". In master, i want to have all of the fileds that are used in all of my "lookup" tables for postfix, corier and amavis as well as some 'non-lookup' customer contact info. I'm wondering if there is a way to make it, so that my lookup tables "pull" their data from the master table and update dynamically when the master has been modified. I'll admidt now, i did look through the manual and did a search on the website, but i was far from exhaustive in my search i'm sure. I'm not looking for someone to spell this out, rather just perhaps a pointer to a particular portion of some document that might explain this. Thanks in advance Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]