Results 1 to 2 of 2
  1. #1
    chasm58 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2016
    Posts
    4

    Question QueryForm Design to populate one Table from another Table


    I have been struggling with this. I have a simple DB with 2 Tables; "Product" and "CustomerOrder".
    I need to create a new record in the CustomerOrder Table by selecting a variable number (up to as many as 20) of Products from the Product Table.
    I would like to design a form with a search button where the user will enter text (Field1 from Product Table) to build the Customer Order record.
    All other Fields from the Product Table will then be added to the Customer order record.
    I will then need to generate a Report to list the Customer Order # along with all of the Products that were added.
    T think I may be making this more complicated that it needs to be.
    Any help would be greatly appreciated!

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like you are missing a table - you need an 'orderline' table which provides a many to many relationship between products and customers. For ideas how this works, look at the access templates. Northwind will cover more than just your requirement, otherwise see what you can see under invoices or orders

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

Similar Threads

  1. Replies: 2
    Last Post: 06-09-2012, 03:16 PM
  2. Replies: 8
    Last Post: 03-24-2012, 11:03 AM
  3. Bulit Report off the queryForm
    By BorisGomel in forum Forms
    Replies: 2
    Last Post: 05-04-2011, 11:32 AM
  4. table design: one big table vs. multiple small tables
    By lstairs in forum Database Design
    Replies: 3
    Last Post: 12-31-2009, 08:46 AM
  5. Use form to populate a table from another table
    By sammer021486 in forum Forms
    Replies: 3
    Last Post: 09-28-2009, 09:06 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