If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to design a hierarchical structure output to Indesign
This database outputs to Indesign for printing and needs to be
structured around what it does. The database worked until recently we needed to add products of a different type from clothing. The product number is the name of a product for a company for example some type of clothing, a sweater. ProductrodNum, size, price Skew:skewNum, prodNum, color This works great for clothing, sweaters, shirts where there are only size attributes and color for the skew. But for a company that advertises tennis shoes for example this wouldn't work. There would be other attributes such as upper sole, whatever. So to normalize it I thought of ProductrodID, prodNum AttributesrodID, attribute Skew:skewID, ProdID, skewNum, color I am not sure this is it. It may need a parent child relationship in product to attributes. Is there a way to get rid of the attributes table and just have product and skew so it works also for the clothing? thanks, |
Thread Tools | |
Display Modes | |
|
|