UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Form With 2 Many To Many Relationships, Access 2013    
 
   
MWats503
post Aug 18 2017, 04:27 PM
Post#1



Posts: 5
Joined: 18-August 17



I am developing a database to keep track of phone calls to members. The table has member names their physician name and each member can have multiple measures. I am showing the measures in a sub-form.
The question is this, My call screen is designed to only show one member at a time and you have to hit a next button to get to the next member. Some times a phone number may have multiple members and each of those members may have multiple measures.
So what is the best way to display this relationship on one screen? In other words, I need to be able to show when there are multiple members.

Thanks,
Mark
Go to the top of the page
 
MWats503
post Aug 18 2017, 04:42 PM
Post#2



Posts: 5
Joined: 18-August 17



The subject should say 2 1 to many relationships not many to many
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 02:03 AM