S
SJW123
I have set a Relationship, and specified Referential Integrity, but I am
having trouble recording on the many side of the Relationship. I am trying to
populate the field via a cbo and I should be able to enter new data into the
table via a cbo, which then copies to the master. I am receiving the correct
message asking whether I wish to add new data, but when click yes, the error
msge appears - stating no record can be written on the many side if there is
no corresponding Record on the one side.
I have successfully done this before ie.added new data via a cbo and the
many sided tableID is copied to the corresponding field in master, but I
cannot replicate the process. I was told one solution was to "do an explicit
save of the Record on the Form, by setting Me.Dirty = False". Is this the
best solution? and if so, how can I do this?
hopefully this makes sense and many thanks
Steven
having trouble recording on the many side of the Relationship. I am trying to
populate the field via a cbo and I should be able to enter new data into the
table via a cbo, which then copies to the master. I am receiving the correct
message asking whether I wish to add new data, but when click yes, the error
msge appears - stating no record can be written on the many side if there is
no corresponding Record on the one side.
I have successfully done this before ie.added new data via a cbo and the
many sided tableID is copied to the corresponding field in master, but I
cannot replicate the process. I was told one solution was to "do an explicit
save of the Record on the Form, by setting Me.Dirty = False". Is this the
best solution? and if so, how can I do this?
hopefully this makes sense and many thanks
Steven