Subform Autonumber doesn’t update many sidetable

[RxExec]

Subform Autonumber doesn’t update many side table

I’ve got an Access form (ProtocolPatients) containing a continous subform based on a 3 table many to many relationship query. With a comboBox in the main form, I select a protocol number and the subform populates with the patients for that protocol. The main form and subform are linked by Protocol_ID. Works great so far.


The problem is when adding a new patient record in the subform, the new Autonumber doesn’t update the many side ProtocolPatients table with the new patient_ID. The (Patient_ID) does show up in the one side Patients table. All other info is entered in the new record updates to correct tables.

What am I missing? Thanks for the help.

 

[RuralGuy]

Many-2-many relationships need to be maintained by *you* unless you deal with each many side one at a time in a Form/SubForm arrangement.

 

[RxExec]

Thanks RuralGuy, I am fairly new to Access... could you elaborate a bit?
Do you mean that I or the user would need to enter the new Patient_ID manually with this form/subform arrangement because they are linked by Protocol_ID?
Or do I need to change the design of the query so that Patient_ID updates in the PatientProtocols table?

Thanks Again

 

[RuralGuy]

A Form/SubForm arrangement will update the ForeignKey field of the RecordSource of the SubForm if *that* is the field you use as the LinkChildField. Access will *not* search out any other tables with a relationship that might also have this value as a Foreignkey field; nor will it look for a link table that defines a m:m relationship. The only thing is built into Access is what I just described for the 1:m relationship of a Form/SubForm.