Discussions

Expand all | Collapse all

Limit the Related Field on the Child Table, based on a value in the Parent Table

  • 1.  Limit the Related Field on the Child Table, based on a value in the Parent Table

    Top
    Contributor
    Posted 04-30-2019 16:45
    I would like to be able to limit the related records from the Parent Table when choosing which parent on the Child Table.

    Example: Audits in the Parent Table, and Audit Reports is the Child Table. When choosing which Audit to relate the Audit Report to, I only want to see the active Audits (based on the Status field on the Audits table).

    Is this possible?


  • 2.  RE: Limit the Related Field on the Child Table, based on a value in the Parent Table

    Posted 04-30-2019 18:29
    Absolutely! All you need to do is:

    1. Create a report in your audits table where status = active
    2. right click on the record picker for audits on your form
    3. pick your report from this dropdown:



    Pro tip -- limit your report to 1 column if you only want to see 1 field to represent each record in the picker.


  • 3.  RE: Limit the Related Field on the Child Table, based on a value in the Parent Table

    Top
    Contributor
    Posted 04-30-2019 19:05
    Thank you!

    Is there a way to make that work in Grid Edit as well?


  • 4.  RE: Limit the Related Field on the Child Table, based on a value in the Parent Table

    Posted 04-30-2019 20:26
    Yes indeed.
    What you do is to make a new form called, perhaps,  Grid Edit form.  show the fields that you want to have on your grid edit report and also setup that report to filter the drop down list.

    now that you have more than 1 form you will have a section for Forms usage and you can specify your "form" to be used for Grid Edit.  The form is really just used as a way to specify the fields to show in Grid Edit and to have more control over the drop down fields in Grid Edit mode.