Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Lloyd_A is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    8
    Sorry I should have explained a bit more, it's what you mentioned in post #4.



    So the user wants to be able to call up the customer details form, click into the discount sub form and see a list of all the products and the corresponding discount for those each of those products, for example below;

    Customer A (Form)
    Discount (Subform)
    Product Standard Price List Price Discount % Discount Price
    Product 1 £5.00 £20.00 8 £18.40
    Product 2 £2.00 £10.00 10 £9.00
    Product 3 £20.00 £50.00 25 £37.50


    Does that make more sense? then the user can also go in and update the discount percentages which will then intern update the discount price field.

  2. #17
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Main form/subform setup.

    Main form - combobox containing customer selection, no record source needed for this

    Subform:
    - record source is a query, all fields from discount table plus the other fields as needed (display only)
    - subform will be linked to main form with the customer id
    - the product description will be a combobox with the product ID as its control source

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-03-2016, 02:30 PM
  2. Access - product list by customer margin
    By Evans2 in forum Access
    Replies: 1
    Last Post: 11-29-2015, 06:21 AM
  3. Replies: 3
    Last Post: 06-26-2014, 10:08 PM
  4. Replies: 5
    Last Post: 03-23-2014, 09:01 AM
  5. Replies: 3
    Last Post: 09-03-2012, 04:54 PM

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