Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

parent - child and calculated fields 11 Jul 2012 04:22 #2778

  • mark
  • mark's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thank you received: 0
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.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.190 seconds
Great UX great performance and definitely a time saver. It only took me 10 minutes of playing around before purchasing a subscription and right now I just want to throw more money at you! I just started a new project and after just 4h I can already tell it probably saved me several days of work. I'm building a wholesale ordering system with sales rep management. I have not looked at the code yet but so far: impressive.
flip (Forum)

Get Started