linking subform to form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a RefundRequest table (many) linked to a Provider table(one). I have a
form to update the RefundRequest table and a subform to update the Provider
table. The linking field is ProviderTaxID. I have updated the link
master/child fields for the subform. However, when I input a ProviderTaxID on
the subform, it does not automatically populate the same field in the
RefundRequest table.

This should be easy, but the answer eludes me.
 
Paulo,

It sounds like your master and subforms may be reversed. A
master or main form should hold the 'one' record of a
one-to-many relationship and the subform should hold the
'many' records.

Does one RefundRequest have many Providers or is it really
one Provider that has many possible RefundRequests? If it is
the latter, you are reversed with your forms.

When you enter a record on a master record and then enter a
child record on the subform the child record will inherit
the ID or linking field from the master record. It does not
work in reverse where you enter a child record and the
master record is created.
 
Back
Top