Showing Number of Related Records on Parent Form

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Showing Number of Related Records on Parent Form

Tagged: 

Viewing 4 reply threads
  • Author
    Posts
  • August 24, 2019 at 2:28 AM #36469

    John Nichol
    Participant

    On a parent form layout, is it possible to show the total number of records in a related child form? For example, if you have a parent form for Clients, and a child form for Invoices, is it possible to show, on the parent form, the total number of invoices for a given Client?

    Thanks,
    John

    August 25, 2019 at 2:28 AM #36479

    Brendan
    Keymaster

    Hi John,

    Yes it’s possible.

    Add a Calculation field and when you add a reference to a Link to Form field, Tap Forms will generate a COUNT() function if the child field referenced is a non-numeric type field.

    Hope that helps.

    Brendan

    August 25, 2019 at 7:57 AM #36490

    john cesta
    Participant

    Add a calculation field and put what in it?
    Thanks

    August 25, 2019 at 10:05 AM #36494

    john cesta
    Participant

    Never mind I get it. By virtue of making the link to form field the count is in the field.

    August 25, 2019 at 8:01 PM #36498

    Brendan
    Keymaster

    Yup, that’s correct.

  • Author
    Posts
Viewing 4 reply threads

You must be logged in to reply to this topic.