Results 1 to 7 of 7
  1. #1
    Hanlou is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2021
    Posts
    1

    Exclamation Bill of material and orders

    Hi people please help 🙏

    So I've made a bill of material which would consist of my product and within the product there are 'items', lets say for exampe:

    Product = BREAKFAST

    Items =

    EGGS 1.00
    TOAST 1.00
    COFFEE 2.00



    TOTAL 4.00

    I think I can understand how to make this work.

    But let's say I was making a customer order how do I get just the product BREAKFAST and total of 4.00 show on an order please? I can't figure out this step?

    So for example:

    Order 1001 ...
    BREAKFAST 4.00
    LUNCH 5.00
    DINNER 10.00
    Total = 19.00

    Here I'm only showing the products, not all of the break down of how the product was made up. Hope that makes sense!

    Thanks so much
    P.s Complete Newbie please explain in the most basic way you can! Thanks

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    You could have a field in your table for MealType?
    So for Breakfast, Eggs are 1.00, but for Dinner they would be 2.50 ?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Breakfast belongs in its own table - a record for every type of whatever this is. Components belong in their own table along with the foreign primary key value from the types table. Prices in this table also. That way you should be able to get out of the db whatever it is you want. For example,
    - form/subform with type in header and components in subform list
    - Totals query grouped by type
    - use of domain aggregate functions such as DSum with criteria (i.e. total all records in a field where type = Breakfast)
    - and so on.

    EDIT - Might be a good idea for you to study db normalization. Perhaps
    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    If you can upload a zipped copy of your database we can take a look at your tables.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Hanlou,

    You may get some insight from this post and the thread dialog.
    It would also be helpful to you and readers if you could describe you business processes with some examples.
    Specifically could you tell us more about your Bill of Materials ideas as they relate to your business.

  6. #6
    Join Date
    Oct 2023
    Posts
    2
    Hi everybody
    I need a sample access program for BOM.
    The program is multi-level.
    Show the main product along with the sub-assembly and the constituent parts of the sub-assembly.
    Can someone help me and provide me with a sample program where the code can be edited?
    Thanks to all

  7. #7
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi
    You should start a new thread with your question, that way you will get a quicker response.

    If you can upload a zipped copy of your current database we will take a look for you.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Bill of Material Help
    By TheLostDrafter in forum Access
    Replies: 10
    Last Post: 10-12-2023, 06:09 AM
  2. BOM database - Bill of Material
    By robw in forum Database Design
    Replies: 5
    Last Post: 03-30-2020, 01:33 AM
  3. Replies: 13
    Last Post: 01-21-2018, 08:55 PM
  4. Replies: 2
    Last Post: 11-01-2016, 09:04 AM
  5. Replies: 4
    Last Post: 04-22-2015, 05:46 PM

Tags for this Thread

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