Forum Discussion
Add pop up subform to add records unique to one field
I'm not sure if I'm wording this correctly. I have a main form with a field that is linked to a subform. This field will generate at least one set of numbers unique to the original field but will pot...
I would not open a second form. I would embed the subform in a subform control on the main form and use the Parent/Child Linking Fields property of the subform CONTROL to handle the related fields.
That said, I'm not sure I follow the exact process anyway. Why are you not using the Primary Key of the table bound to the main form as the Foreign Key in the related table?
I forgot to mention that the main form already has a primary key.