I have a main form called Course Details. The course shows at the top of my form with some details also showing on the first tab below. In the first tab below I have 2 subforms. One to show audits and the other to show duplicates (if the course has been duplicated elsewhere).
On the 2nd tab I have another subform called units. On this sub form I have 2 sub subforms one for Audits and one for duplicates.
The main course form is linked to the course audit table and course duplicate table 1 to many with the main course form being the parent.
The unit details table is also a child of the course table, and also a parent to the unit audit table and the unit duplicate table.
It all looked like it was working well. I could add a course and add many details about audit and duplicates for the course. I then tried adding unit details to the course and that worked well too. I also added unit audit details and unit duplicate details and it all seemed to work well.
When I went back to the first tab (course details) and checked each record it seemed to duplicate each record to compare with how many units I had added. E.g. if I had 2 courses and added 5 units to a course, I would then have five instances of that course showing in the course area. When I closed the form and checked my course table only one instance was showing there.
How do I stop extra instances showing on my form?