Hi, I have a mainform with a subform 1 to many relationship.
I am trying to auto create a new record in the subform for each record in the mainform if a record does not already exist.
Mainform has a PK MainID, the subform has a PK SubID, FK MainID. Obviously when I create a new record in the subform the suform PK is added and the FK is added.
I created a query where I can see all records in the Main form where there has been a record created in the subform, it also shows where there are no records in the subform (subform PK, FK are null)
I tried an update query but it did not work.
Is there a way to do this?
Many thanks.
Fen
I am trying to auto create a new record in the subform for each record in the mainform if a record does not already exist.
Mainform has a PK MainID, the subform has a PK SubID, FK MainID. Obviously when I create a new record in the subform the suform PK is added and the FK is added.
I created a query where I can see all records in the Main form where there has been a record created in the subform, it also shows where there are no records in the subform (subform PK, FK are null)
I tried an update query but it did not work.
Is there a way to do this?
Many thanks.
Fen
