Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Many to Many Relationships
Timothy Henley 
    
6 years ago
Hi there, I am new to all of this.  I have watched the free course on youtube and decided to sign up for the classes here.  I also watched some of the other tutorial on youtube.  I am working on a database for a volunteer group I am part of.  I saw the tutorial on Many to Many relationships.  I am trying to design a form that actually would be based more on the one to many relationship described in the video.  I have a table with our members and a table with hospitals these member are assigned to.  I am have designed a form to enter the members info on the members table.  However, from that form I would like to be able to update the hospital table to reflect the hospitals they are assigned to.  Only one volunteer is assigned to each hospital, but each member is assigned to multiple hospitals.  It seems to me it shouldn't be too difficult to do, but maybe I am trying to run before I walk.
Richard Rost  @Reply  
           
6 years ago
Welcome Timothy. Yeah, many to many relationships aren't easy at all. In fact, doing them right can be very challenging. I spend a lot of time on them in Access Expert 7 and of course my Relationship Seminar.  If you have only one volunteer per hospital then you can just store the VolunteerID in the hospital table (only one). If the hospital has multiple members but those members are unique to that hospital, then a one to many relationship will work. However, if those members can ALSO belong to other hospitals, now you need a many to many relationship with a junction table.
Timothy Henley OP  @Reply  
    
6 years ago
Thanks.  I look forward to getting to that point.  I imagine that at that point you will discuss forms for working with those relationships.
Richard Rost  @Reply  
           
6 years ago
Yep. If you look on the Seminar page, you'll see that there are forms for products to vendors, and vendors to products. It's the typical many to many setup where one product can come from multiple vendors, and one vendor will of course have multiple products.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/6/2026 1:15:46 PM. PLT: 0s