Child report table on Parent record

done, thank you.

This works, but the field list is limited to what I assume are "numeric type fields".  Is there any way to combine formula text fields from a child to a single field in the parent.  example;  I have a field on each job card for items used, I want to get all the items used accross all job cards and summarise in 1 field on the parent record

Can you give some examples of the current set up you have and the information in the field you are looking to summarize?  Maybe an example of what you want it to look like?

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

Use the text values for the grouping or rows, not the summary

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.

I guess i'm a little confused on how that would work.

What I'm trying to do is create a report based off of one of the child tables, but have it display data linked from the other child table and the parent table.

Or have a parent table that can display data from both child tables.


So for example:
Lab table(child table), shows list of providers(child table) from a specific practice(parent table)

If the providers could be concatenated into one cell that would be perfect.

I'm wanting to see in the report:
Lab name | project name| provider(or list of providers concatenated in one cell)
...
...

re: "Or have a parent table that can display data from both child tables."

You can float up data form a limited number of children.  I had asked how many, in practical terms you will have.  Let's say that in practical terms, 5 is enough.

The technique is edit the relationship between 1 parent has many Children to make a summary of the Minimum Record ID# of the child records.  Call it [Minimum Record ID of Providers #1].  Look that field up down to the Child table.

Then make a reverse relationship where 1 child has many parents and on the right side use the field [Minimum Record ID of Providers #1]

Lookup the text value to the parent Practice record.

Then duplicate the field [Minimum Record ID of Providers #1] and call it [Minimum Record ID of Providers #2]

But change the Summary filter to make it the minimum record id# subject to the condition that the [Record ID#] > [Minimum Record ID of Providers #1].  On the main "forward" relationship, lookup that [Minimum Record ID of Providers #2] to the child table.

Conveniently, QuickBase will have duplicated the reverse relationship when you duplicated that field.  Edit that relationship  to look up the text value to the Parent record.  That's two so far we have done.

Basically just keep going and looping.  if you have say a half a dozen to do, then it will work OK.,  if you have dozens of loops to do, then you risk getting into performance issues with your app. 

Once you get enough of them floated up, you can concatenate them together with a List function)

If you are going to go to the trouble of all those reverse relationships, you might as well just flip the original.

So make Each Provider, has many Clinics, and make that 4 or 5 times.

**Still not recommended to handle it this way, but if you are going down that path, you might as well cut it down.**