Results 1 to 3 of 3

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

  1. #1
    PinkDuster's Avatar
    PinkDuster is offline Advanced Beginner
    Windows 7 64bit Access 2013 32bit
    Join Date
    Aug 2017
    Cleveland area

    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
    tPrice table
    ProdID (fk to tProduct table)
    Price (currency)
    PriceType (retail,whole)

    tProduct table
    ProdID (key) either autonum or upc code

    tInventory table
    ProdID (chosen from tProd tbl)

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    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, 09:46 AM
  2. Replies: 6
    Last Post: 02-28-2015, 10:57 AM
  3. Replies: 36
    Last Post: 12-09-2013, 01:20 PM
  4. Replies: 3
    Last Post: 05-28-2013, 10:27 AM
  5. Update multiple product id's
    By thanosgr in forum Access
    Replies: 10
    Last Post: 02-24-2012, 06: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
Tech Forums: Microsoft Office Forums