lilysdaisys
New Member
I've come to a problem with which I would like to ask you for some directions. I have database as in image below.
1 In my application I have products predefined, so they automaticaly popup in textbox, depends on first letter. My problem is that every product available in multiple colors. And i dont know how to make a proper table. Should i make one table only with colors?2Let's say Customer orders 5 monitors, and 4 keyboards that are all on same Order. Where should I have quantity? In my OrderProduct table? 3 What if customer want a custom sticker or his logo printed on item selected. If I select print on item or sticker in my application, where in database should this be stored? Also on OrderProduct?