Skip to main content
Question

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

  • April 30, 2019
  • 0 replies
  • 77 views
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?
This topic has been closed for replies.

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.
Terms & ConditionsAccessibility statement