Results 1 to 3 of 3
  1. #1
    PinkDuster's Avatar
    PinkDuster is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2017
    Location
    Cleveland area
    Posts
    65

    Can this be done - Multiple Prices for a Product that aren't percentages

    I'm new to Access and working on a sales and inventory database. The inventory products have retail and wholesale prices; the wholesale prices are not percentages of the retail prices. I would like to have a structure that enables creation of an order form where I can select either the retail price or the wholesale price for each line item. Is this possible, and what might be the best structure? TIA

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    tPrice table
    ------------
    ProdID (fk to tProduct table)
    Price (currency)
    PriceType (retail,whole)


    tProduct table
    ProdID (key) either autonum or upc code
    ProdName
    descrip
    etc

    tInventory table
    ProdID (chosen from tProd tbl)
    Price
    etc

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Yes it can be done.

    I would store the wholesale and retail prices, and the PriceEffectiveDate in a table. I suggest storing both since
    one is not a percentage of the other.

    Here is a link to info re database planning and design that may be helpful.
    I recommend you work through 1 or 2 of the tutorials under Practical Experience at that link.

    Good luck.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 12-25-2016, 10:46 AM
  2. Replies: 6
    Last Post: 02-28-2015, 11:57 AM
  3. Replies: 36
    Last Post: 12-09-2013, 02:20 PM
  4. Replies: 3
    Last Post: 05-28-2013, 11:27 AM
  5. Update multiple product id's
    By thanosgr in forum Access
    Replies: 10
    Last Post: 02-24-2012, 07:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums