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?