show child records with same parent
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,...
Forum Discussion
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.
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.
- As always, you are a genius. Thank you so much.
