Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 years ago

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

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. ...
Relationships
Tables and fields
CharlieMurawski's avatar
CharlieMurawski
Qrew Cadet
7 years ago
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.
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    7 years ago
    Thank you!

    Is there a way to make that work in Grid Edit as well?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.