One to Many
I have a 'Contacts' table and need to create relationships for each contact in that table. For example, Mary (primary contact) has a father (Fred), mother (Betty) and sister (Sue). I need to, while v...
Forum Discussion
In order to show the child record on the Parent form, you put the Report link field on the form. Typically that field is created when you build the relationship. Set the form property to show the child record on the form, as opposed to just a link.
That will allow you a direct link to "Fred" in your example.
The other part of your question is to want to show child record data directly on the parent record as opposed to as an embedded report.
You can use the new Combine Text summary field on the Relationship to do this. Make a summary field, chose combine text, and summarize the name field subject to the filter where the relationship is equal to Father.
That will allow you a direct link to "Fred" in your example.
The other part of your question is to want to show child record data directly on the parent record as opposed to as an embedded report.
You can use the new Combine Text summary field on the Relationship to do this. Make a summary field, chose combine text, and summarize the name field subject to the filter where the relationship is equal to Father.