J John O'Malvern Member Local time Today, 14:17 Joined Mar 25, 2024 Messages 75 Oct 1, 2025 #21 Just to confirm, the problem in the original post has been resolved. thank you all.
Gasman Enthusiastic Amateur Local time Today, 14:17 Joined Sep 21, 2011 Messages 17,407 Oct 2, 2025 #22 John O'Malvern said: Just to confirm, the problem in the original post has been resolved. thank you all. Click to expand... Mark it solved then. That will help prevent more posts on the thread. Top right of thread.
John O'Malvern said: Just to confirm, the problem in the original post has been resolved. thank you all. Click to expand... Mark it solved then. That will help prevent more posts on the thread. Top right of thread.
J John O'Malvern Member Local time Today, 14:17 Joined Mar 25, 2024 Messages 75 Oct 2, 2025 #23 Gasman said: Mark it solved then. That will help prevent more posts on the thread. Top right of thread. Click to expand... Thanks. I hadn't noticed that button. (Writes Mr Unobservant.)
Gasman said: Mark it solved then. That will help prevent more posts on the thread. Top right of thread. Click to expand... Thanks. I hadn't noticed that button. (Writes Mr Unobservant.)
P Pat Hartman Super Moderator Staff member Local time Today, 09:17 Joined Feb 19, 2002 Messages 48,175 Friday at 2:56 PM #24 John O'Malvern said: I've not heard the term 'many to many table' before. Click to expand... Usually it is called a junction table because it "joins" two 1-m relationships. There is no natural way to create a m-m relationship.
John O'Malvern said: I've not heard the term 'many to many table' before. Click to expand... Usually it is called a junction table because it "joins" two 1-m relationships. There is no natural way to create a m-m relationship.
P Pat Hartman Super Moderator Staff member Local time Today, 09:17 Joined Feb 19, 2002 Messages 48,175 Friday at 2:58 PM #25 Gasman said: Mark it solved then. That will help prevent more posts on the thread. Top right of thread. Click to expand... It is helpful for those who find this thread later to describe your solution. To handle the change in relationships, you should use a subform for the new m-m relationship and the main form for the original single table.
Gasman said: Mark it solved then. That will help prevent more posts on the thread. Top right of thread. Click to expand... It is helpful for those who find this thread later to describe your solution. To handle the change in relationships, you should use a subform for the new m-m relationship and the main form for the original single table.