Yes, create a global field for Status, then create another instance of that table in your relation diagram where you connect the global field with the status field. The base your list view on the 2nd instance.
Have a good look in the sample files that come with FileMaker, they are unlocked and are good study material if you are new to Filemaker.
Are you refering to the starter solutions or are there sample files installed with FMP?
I tried using a script and almost have it working. I'm guessing it's a syntax problem.
Script Action is Perform Lookup
Criteria is Find Records When Projects:StatusUID is Projects:GlobalStatusID
Both field types are numbers
If I replace GlobalStatusID with and actual value such as 2 everything works fine. Any ideas?
I figured it out. Thanks again for your help.