Forum Moderators: open

Message Too Old, No Replies

Cross-link default values in MySql tables.

         

digisales

7:54 pm on Jul 25, 2009 (gmt 0)

10+ Year Member



I hope I can ask this question in a way that makes some sense . .
Basically, what I need to do is be able to use MySql in a way similar to an Excel spreadsheet. Here's what mean:

Each subscriber to my site is able to save data to 3 different tables in a MySql database - meaning there 3 tables for each subscriber. Within the structure of those tables there are several default values that are the same for all tables. (Because of the way the site operates, it is necessary for each table to reflect the same default value.)

My question is:
Is there a way to set up a "Master Default Table" and have each subscriber's tables "call" the default values from that Master?
That way, if I need to change a default value, I can do so from the Master table, and the change will occur in all tables that include that same default value.

Any help is much appreciated, even if you just want to direct me to a tutorial or something. I'm new to MySql, and I'm learning on my own.

Thanks.