J
Janna Poliakov
Guest
Hi.
I have tables of possible values for some fields. For example, I could have a table called "Color" and it will contain entries: red, green, blue. Then, in another table, if one of the fields is "color", then I want it to contain rows for all possible combinations of my entries from the "color" table. (there may be several "field" tables, all used by this one table.) I can't do this in a view, because I will need to add at least one column in the new table (for example, a "value" for all possible combinations of my fields. If I was to add a row to "Color", the next time I open the otehr table, I want it to automatcly add all required rows for this new color.
What is the best and easiest way to do this?
Thank you in advance,
I have tables of possible values for some fields. For example, I could have a table called "Color" and it will contain entries: red, green, blue. Then, in another table, if one of the fields is "color", then I want it to contain rows for all possible combinations of my entries from the "color" table. (there may be several "field" tables, all used by this one table.) I can't do this in a view, because I will need to add at least one column in the new table (for example, a "value" for all possible combinations of my fields. If I was to add a row to "Color", the next time I open the otehr table, I want it to automatcly add all required rows for this new color.
What is the best and easiest way to do this?
Thank you in advance,