AnsweredAssumed Answered

Plz help me set up my database. Conditional value lists, invoice,line items and more.

Question asked by DanielleYoung on Jan 8, 2014
Latest reply on Jan 9, 2014 by philmodjunk

Title

Plz help me set up my database. Conditional value lists, invoice,line items and more.

Post

     I am attempting to create a database which seems complex to me. I have struggled for 3 days now .  I want to make a database which tracks store products, and their weekly price changes. I also want to be able to simulate  buying the products. Based on the research I have done this is what I think I need.

     Table

     Profile - User can create a profile (easy I can do this)

     Table

     Shopping Cart (invoice) - Will use to simulate buying products.

     Table

     Line Items 

     Table

     products - 

     Table

     Sales prices - store and update product price changes

     Table

     I would like for the products to have conditional value lists like this: 

     Store---> Item type---> Item type2---> Product

     if someone could plz help me plan this out i would be so grateful.

Outcomes