Forum Discussion
MCFNeil
9 years agoQrew Captain
Geoffrey,
Combining multiple variations of text from a child to a parent via a reverse relationship will not work, because you'd have to account for every variation of the child. And the number of children. So if you had 10 child cards, you'd have to have 10 reverse relationships, and then a master formula to recombine them.
Additionally making each of those sequential relationships will require about 4-5 new fields for each of them. This will take a huge hit on your app performance.
My recommendation:
On your child "Cards" table, create a summary report that combines like values in the text field.
>
Then make a report link on your parent table, and use that summary report on the form.
>
This should give you the summed text values, and display them on the form.
I know its not perfect, but from what I can tell this might be a good option.
p.s. You might consider addressing how they input the multiple items. That sounds like it could be handled differently, which might give you better reporting.
Combining multiple variations of text from a child to a parent via a reverse relationship will not work, because you'd have to account for every variation of the child. And the number of children. So if you had 10 child cards, you'd have to have 10 reverse relationships, and then a master formula to recombine them.
Additionally making each of those sequential relationships will require about 4-5 new fields for each of them. This will take a huge hit on your app performance.
My recommendation:
On your child "Cards" table, create a summary report that combines like values in the text field.
>
Then make a report link on your parent table, and use that summary report on the form.
>
This should give you the summed text values, and display them on the form.
I know its not perfect, but from what I can tell this might be a good option.
p.s. You might consider addressing how they input the multiple items. That sounds like it could be handled differently, which might give you better reporting.
GeoffreyHarmuth
9 years agoQrew Captain
Ok i'm with you. the summary report actually looks ok. Just on the report link, not sure how to display this report on the parent table through a report link field.