Add a field to your users table to record their status.
Set up scripts and portal filters that exclude User records that are "inactive".
Value lists can be set up as conditional value lists that only list "active" users as well.
Ok, I added a field in my users table that records their status as a radial set with "Active" or "Inactive" as an option.
Now, in my transactions table I have an ID field that is setup as a value set drop down that gets records from my users ID field. How do I now limit that to only show those user IDs that are active? What does this script look like and how do I apply it to this field? Sorry I'm not a knowledgeable script guy and fairly new to Filemaker Pro. Any help would be appreciated.
It's not a script, it's a value list based on a specific relationship or a value list based on a calculation field (option 1 in forum tutorial).
Here are some links on conditional value lists:
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list