Dear Forum,
I would like to create a main form and a subform. However, I don't want to use the ID of the main form as the foreign key in the subform.
Instead, I want to use another field, ID2 (unique), as the foreign key. This ID2 is also unique across all other tables. No matter what I try...