Results 1 to 2 of 2
  1. #1
    sesproul is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    50

    Linked table Query based form

    Hello,



    i know this answer is out there, but when I changed jobs I lost all my bookmarked solutions.

    Basically
    table A Products
    table B Subassemblies
    Table C Prod_Sub link table

    table c is the Many:Many relationship between Products and their sub assemblies.

    So I want to have a form that I select a Product, then a sub assembly, and have the form update the link table. As I said, I had a working version of this before, but have since lost the DB/


    I do remeber that it involved creating a Query that linked the three tables and using the form wizard to base a form on this query.

    thanks


    Steve

  2. #2
    sesproul is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    50
    found the link.


    MANy to Many form

    http://articles.techrepublic.com.com...1-5285168.html

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

Similar Threads

  1. Replies: 3
    Last Post: 01-21-2010, 08:10 PM
  2. Replies: 2
    Last Post: 10-27-2009, 07:09 AM
  3. Query on a linked table?
    By SilverSN95 in forum Queries
    Replies: 1
    Last Post: 09-26-2009, 03:00 PM
  4. Form Based Query/Filter
    By Micon in forum Access
    Replies: 0
    Last Post: 11-07-2008, 09:25 AM
  5. Run a PivotChart form based on query
    By Suzan in forum Queries
    Replies: 0
    Last Post: 06-11-2006, 03:48 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
  •  
Other Forums: Microsoft Office Forums