Results 1 to 3 of 3
  1. #1
    green369 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020

    Smile database design for purchase order details by a customer



    iam new to database designs i have a task to maintain details of the "customer purchase order details "

    in this
    one customer will give order with order number, product variety, category of the product, quantity(no's) of the product in that category, finally total no.of items(quantity(no's) of the products of all category) of the product in that purchase order.

    for example
    customer : james
    puchase order number is 123456
    product varieties are : 1.veg 2. Non-veg
    product categories are :1. fruits 2. vegetables 3. meat and so on
    Quantity ordered : In variety 1. veg, in category- fruits, apples - 30 packs, mangoes - 20 packs
    In variety 2. Non-veg, in category- meat, pork - 30 packs, Beacon - 10 packs
    total purchase order quantity : apples - 30 packs + mangoes - 20 packs + pork - 30 packs + Beacon - 10 packs = 90 packs

    like this i need to record data for a customer and his all purchase orders

    kindly help me how to design this

    it will be very helpful for me if any one can sort the issue

    thanks in advance


  2. #2
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Essex UK
    Is this a business requirement or a homework assignment
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Living in Scotland UK
    Hi Green

    Can you upload a zipped of copy of your current attempt at the database?

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

Similar Threads

  1. Replies: 18
    Last Post: 06-19-2015, 12:38 PM
  2. Replies: 4
    Last Post: 04-30-2014, 09:54 PM
  3. Replies: 1
    Last Post: 01-13-2014, 11:36 AM
  4. Replies: 1
    Last Post: 07-26-2013, 06:01 AM
  5. a simple purchase order details
    By damie in forum Database Design
    Replies: 16
    Last Post: 12-30-2010, 04:14 AM

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 - Senior Forums