I think what you ar saying is that when editing or Adding Client record you are selecting an Associate as a look up from the Associates table, but you just want the user to be offered Active Associates..
no problem,
Make a report of Active Associates on the Associates table.
Set the FORM property on the client form to use that report when selecting an Associate.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com------------------------------
Original Message:
Sent: 09-02-2022 08:26
From: Consuelo Viramonte
Subject: Filtering User field
We have a Clients table and an Associates table. The Clients table has ha field (user type field) that pulls the Associate users which is a key field in the Associates table.
I need the field in the Clients table to show only active Associates users. Can I use a formula? is there another way to do it? Thanks in advance.
------------------------------
Consuelo Viramonte
------------------------------