Skip to main content
Question

Child report table on Parent record

  • April 10, 2017
  • 0 replies
  • 197 views

So I need an answer to 2 questions here:

1)  How do I get the child report table that appears on the parent record to extend all the way accross the screen.  I have attached a pic.

2)  Is there any way to summarise data from multiple child records on the parent record.  So:  one "Job" has many "Job Cards".  how do I for example; get a total of all the hours worked accross all the job cards relating to that job?

For the #1 question, edit the form properties and erase the values where it says maximum height and rows.

For the # 2 question, I assume that you have a relationship where 1 Parent has many Children.  Open up that relationship and on the left side you will see a button to make a summary field.

  • Registered
  • April 11, 2017
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.

  • Registered
  • April 11, 2017
Joshua,

Rather than making a reverse relationship, I'd recommend making a joined table.

Call it something like "Practice Providers".

Each Practice will have many practice providers 
AND
Each Provider will have many Practice Providers.

Then you can have multiple assignments and gives you a lot more flexibility for reporting, and appointment setting.