Hello,
I am creating a database right now and I have a table with a Primary Key that is linked to another table with a 1 to 1 Relationship.
I created a query and used all the fields that I wan´t to edit with a form.
My problem is, if i don´t fill a field, that is linked to the second Table with the primary Key, and I Save the record, I can´t edit the fields that are linked to the second table anymore, because the primary key for the second table wasn´t generated.
So I thought I could autofill the forgein keys, but it is harder than I thought.
Does anyone know a way to do that?
I am creating a database right now and I have a table with a Primary Key that is linked to another table with a 1 to 1 Relationship.
I created a query and used all the fields that I wan´t to edit with a form.
My problem is, if i don´t fill a field, that is linked to the second Table with the primary Key, and I Save the record, I can´t edit the fields that are linked to the second table anymore, because the primary key for the second table wasn´t generated.
So I thought I could autofill the forgein keys, but it is harder than I thought.
Does anyone know a way to do that?