Changing Master/Child Links to Subforms

[TAWise]

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.

 

[KARL DEWEY]

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.