Ok, then I think that with only 3 tables the schema would be too
complex.
Because then it looks to me like M:N relation(r1) between Design and
Type
Then this relation r1 is M:N related to the size. And also quantity is
somehow related to the all of that?
..phew.. :)
Then maybe another way would be
Thanks for replying Tom,
It is 2), but with combinations of 1c) they will be connected to
combinations of type, size and quantity.
e.g.
Person selects
Design 1.. they get a drop down list of available media types (not all
may be available, flyers and posters may be available, but banners not
al
Hi,
there are some questions which you have to answer if you want to
design this app.
1) sizes are connected to the type or to the design, or to the
combinatioin of design&type?
a) all posters have size A5 and A6 (no matter which design), all
banners has size A6, A7 (no matter which design)
b