Look-up fields
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 eve...
Forum Discussion
I wasnt able to figure out how to only display active ones but I was able to add the status to the picker so people can see if they are active or not which works. Thanks!
------------------------------
Rebecca Knecht, MS, ACSM-CEP
------------------------------
If you have a report for active Clients, you can use that report as the picker. Then in the filter of the report do something like Active checkbox = checked.
------------------------------
Dwight Munson
------------------------------