3 Replies Latest reply on Jan 9, 2014 9:10 AM by philmodjunk

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

    DanielleYoung

      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.