0

Parent / Child / Grandchild

Hello there.

I'm a new user and am struggling with the Parent / Child / Grandchild relationships.

 

I have the set-up the following relationships as shown in the picture:

Parent (Projekte)

Child (Arbeitsauftrage)

Grandchild (Reparaturen)

 

For invoicing, I am in the Parent("Projekte") table and I would like to include all individual records associated with this Parent("Projekte") from the Grandchild (Reparaturen) table. I can link table records from Child (Arbeitsauftrage) but the problem is I can only link sums / counts / averages etc. from the Grandchild (Reparaturen) table.

 

Is it possible to include a table with all Grandchildren records in the Parent view so I can then create an invoice with full details?

 

I have checked the videos but can only seem to find details for parent/child relationships and not parent/child/grandchild relationships. Can anyone point me in the right direction for some help?

4 replies

null
    • Fred
    • 1 yr ago
    • Reported - view

    You can create a view element in Projekte and in the formula you can put:

    Arbeitsauftrage.Reparaturen

    and this view will show you all records from Reparaturen that is related to Projekte through Arbeitsauftrage.

    • David_H
    • 1 yr ago
    • Reported - view

    Hi Fred. That's great. I hadn't checked out views yet and the solution was right there. Many thanks.

     

    I see that I cannot get the view on the print out from "Projekte" but I will find another solution.

      • Fred
      • 1 yr ago
      • Reported - view

      Sadly I don't have any tips on printing as I don't print. The print limitation on child tables is very annoying.

      Ninox says they are revamping the print engine, but like anything don't hold your breath.

    • John_Halls
    • 1 yr ago
    • Reported - view

    My understanding is that you cannot print views. You would need to run a script to directly relate the grandchildren to their grandparent and then you would be able to print them. This would be a very easy script to write and run

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 4Replies
  • 124Views
  • 3 Following