Hey Guys,
I have put together the basic layout for a database I need. I think it is far from perfect because I am having a problem with something I would consider a routine concept found on ecommerce websites.
Fortunately, I am not dealing with financial information, but just order details. My problem occurs in the table Pro5000A. Pro5000A contains all of the basic details about the product being ordered. The rest of the product details are stored in tables specific to product types. This way, specific details about a shirt are stored in a table, and details about a pen are stored in a table, etc.
I am trying to devise a way that the details from EITHER ItmShi5000, ItmPen5000, or ItmGen5000 are linked to Pro5000A. But only one for each row in Pro5000A. This way you know the exact details of every order.
Does this logic make sense for this type of order form?
diagram
Also, I explained each table here at www.dajunkyard. com
Thank you for your time!
I have put together the basic layout for a database I need. I think it is far from perfect because I am having a problem with something I would consider a routine concept found on ecommerce websites.
Fortunately, I am not dealing with financial information, but just order details. My problem occurs in the table Pro5000A. Pro5000A contains all of the basic details about the product being ordered. The rest of the product details are stored in tables specific to product types. This way, specific details about a shirt are stored in a table, and details about a pen are stored in a table, etc.
I am trying to devise a way that the details from EITHER ItmShi5000, ItmPen5000, or ItmGen5000 are linked to Pro5000A. But only one for each row in Pro5000A. This way you know the exact details of every order.
Does this logic make sense for this type of order form?
diagram
Also, I explained each table here at www.dajunkyard. com
Thank you for your time!
Comment