show child records with same parent

Question

This has probably been asked before, but I can't find exactly what I'm looking for.

I have a parent table, "Clients." Each client can have many "Cases" (child table).

When I'm looking at a Case, I want to see an embedded report of other Cases with the same Client.

Is this possible?

quickbasecoachd · Answer

Np
Husky dogs love to pull dog sleds. Similarly report link fields love to run reports on forms. So just create a report link field on the child table.

Set the left field in the configuration to be related client. And similarly set the right field in the configuration to also be related client. Ie the exact same field.

What these children have in common is that they have the same parent.

The only thing you won�t be able to accomplish, is that the report link report will include the very record that you�re sitting on. There�s no way to suppress that.

sarahclark · Answer

As always, you are a genius. Thank you so much.

Forum Discussion

show child records with same parent

Related Content

Totaling Child Records Live on Parent Form

Many parent records on a single child record

Pipeline to add Parent record from child import

Add child record through parent form and redirect back to parent form in edit mode

Get latest child record on parent record