Aug 20 2021 06:03 PM
I'm creating a database with 3 tables with many-to-many relationships connecting them. tblSetup contains information about parts. tblOperations contains process steps to make the parts. tblTools contains information on tools used in each operation. Each part has multiple operations and each operation has multiple tools. See pic of relationships.
In my form I get the attached error message. I don't understand why I'm getting it or what I need to change to correct it. Thanks for all your help!
Aug 20 2021 08:15 PM
@Jonathan_Wilkof You'll find a demo of the interface design needed to support many-to-many relationships in a main form/sub form. It's based on different content, but the concepts and principles are the same.
Aug 25 2021 12:45 AM
Hi, Jonathan @Jonathan_Wilkof are you got the solution to that problem or not yet..??
May 16 2022 05:27 AM
@George_Hepworth can you hep me also...
May 29 2023 06:29 PM