I have a Parent- Child table relationship using a parent form and a child subform. The parent table has a autonumber field as primary key and this is linked to the same foreign key in the child table. I can enter a new record in the parent form and the parent table saves it, no problem there.
When I however enter a child record in the child form it saves it in the table with a value of 0 (zero) in the child table foreign key field i.e. the parent table autonumber field value is not being inherited by the child table.
If I manually go and change the value of the child table foreign key field to be the same as that of the parent table autonumber field then it (obviously) does show as in the child form as linked to the parent when I cycle through the records in the parent form.
In the table relationships view the relationship connection between the two tables is there.
What should I look out for, please?
When I however enter a child record in the child form it saves it in the table with a value of 0 (zero) in the child table foreign key field i.e. the parent table autonumber field value is not being inherited by the child table.
If I manually go and change the value of the child table foreign key field to be the same as that of the parent table autonumber field then it (obviously) does show as in the child form as linked to the parent when I cycle through the records in the parent form.
In the table relationships view the relationship connection between the two tables is there.
What should I look out for, please?