Skip to main content
Question

Look-up fields

  • June 20, 2023
  • 0 replies
  • 201 views

I have a field in child table (patients) that pulls the client name from parent table (clients). However I want to only pull clients from the parent table that are active. Right now it just pulls every client in the client table into the dropdown. 



------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------
    This topic has been closed for replies.

    DwightMunson1
    Forum|alt.badge.img+8

    If you right-click and go to the form settings for that field you will see how the picker is displayed. You can set it to be a report where it only shows clients that are active. I do this in a lot of places. 



    ------------------------------
    Dwight Munson
    ------------------------------
      Terms & ConditionsAccessibility statement