I Have followed the Expert Level 7 Many to Many Relationships video and created:
1. CustomerType Table - which stores the 'CustomerTypeID' vs 'Type' (e.g.OEM, Software vendor, Cloud vendor, End User, Consultant). In your video you talked about 'Groups' whereas I have used the term 'Type' instead.
2. Customer Table - with CustomerID, Customer name and other details.
3. Junction Table - which stores the CustomerID and CustomerTypeID. A customer can have multiple Types associated with them.
4. CustomerType Subform - to see the types associated with the customer e.g. a customer may be a Cloud and Software vendor
I then added the CustomerType Subform to a pre-existing Customer Form and it all worked perfectly as illustrated in your video. I can see the Customers, their details and which 'Types' are associated with them.
The problem came when I tried to add the 'CustomerType Subform' to a 'New Customer' Form that I use to add new customers and their details to the 'Customer Table'. As well as add the new customer details to the 'Customer Table' (this works fine); I would like to select (e.g. from a combo box) the associated 'Types' and add this to/ update the Junction Table. After I added the subform, saved and opened: I see only a blank rectangle - whereas on the 'Customer Form' I see multiple entries and a dropdown combo box.
Please advise where I am going wrong or if you have a video lesson that I can purchase that illustrates how do fix this - I am missing the ability update the junction table at the same time as adding new customer details. I would like to do this at the same time rather than as a 2 step process.
Thanks