Results 1 to 2 of 2
  1. #1
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,368

    Many-To-Many, two ways to update Junction table, includes Not In List handling

    I've seen a lot of YouTube examples of how to create the tables for MYM but not so many with good examples of how to update that pesky junction table. This DB has two example forms that can do the job.




    Below form is the familiar looking form/Subform arrangement, with the main form supplying one FK to the junction table and the subform supplying the other FK. This form has the ability to update both the underlying tables of the main form and the subform as well. The subform dropdown has code to add Event records via the 'Not In List' event. Kind of an all-in-one-form functionality.

    Click image for larger version. 

Name:	form-subform.png 
Views:	509 
Size:	23.4 KB 
ID:	41053

    This form features side-by-side listboxes. When an Event is chosen with the combo, the right listbox shows Members currently assigned to the Event, while the left listbox show all the others. You can move Member names from one to the other via arrow buttons or by double clicking the name. This form also lets you run reports to show various Member/Event assignments.

    Click image for larger version. 

Name:	SideSide.png 
Views:	509 
Size:	32.1 KB 
ID:	41054

    MTM Medley-davegri-v01.zip

  2. #2
    hinchi1 is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2017
    Posts
    181
    Thank you, will look at the weekend

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

Similar Threads

  1. Replies: 20
    Last Post: 01-09-2019, 04:12 PM
  2. Replies: 3
    Last Post: 09-15-2017, 05:06 PM
  3. How to link Access to Excel and update both ways?
    By JennyL in forum Import/Export Data
    Replies: 5
    Last Post: 01-23-2017, 11:04 PM
  4. Replies: 1
    Last Post: 08-10-2016, 04:55 PM
  5. append/overwrite (update?) junction table from Excel
    By Atoga in forum Import/Export Data
    Replies: 3
    Last Post: 04-30-2015, 02:34 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