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
This doesnt work in my case because a summary report doesnt allow me to summarize a formula text field (unless I am missing something?) The option for that field doesnt even appear on the drop down