Changing Master/Child Links to Subforms

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

Guest

I have a form called Opportunities that has a Subform called Funding. I
originally set up the link between the two on the "Title" field name. Then I
found out that if I change the "Title" on the Main Form, "Opportunities," the
information on the "Funding Subform" is gone. So I changed the Master and
Child links to another field, "ID." However, now no data is appearing in the
"Funding Subform". I have changed my Relationships and tried numerous other
things but can't seem to find the right combination. Any help will be
appreciated.
 
You need to use fields that relate the two tables that the main and subform
are based upon. Example is tables with a one-to-many relation you would use
the primary key from the one side as Master and the foreign key from the many
side as Child.
 
Back
Top