Parent-Child
I think it’s not possible now to link to a “collection layout” (form) of a child table based on a parent ID mentioned in a grid.
Ex
I have a grid with a list of companies with fields:
- Company ID
- Company name
I’d like to add a field “invoices” in the grid which links to a form with an overview of the invoices of that selected company (based on company ID).
Basically it comes down to this:
I add the parent ID in the table (and change the heading in the grid). Then I should like to link this field to a “collection layout” of a child table with filtering based on the parent ID.
Calculated fields
Additionally, it would be even nicer to precalculate the number of child rows and display that number in the grid instead of the parent ID.