This must be a simple problem, it's just that I can't find a direct way to solve it.
I have a One-to-many relationship, a form with the One table and the subform with the Many table. I want to add records in the subform and I expect the form to recognize they are pertinent to the current record in the One side. Problem is, when I add the record in the subform it always set the field referencing the One table to zero and I want it to automatically restrict it to the current value in the main form.
Is there a way to limit the record automatically without code?