Customized record list based on current user
I have multiple users logging into a database full of thousands of Projects that everyone has access to. I want to allow each user to create their own list of "Active Projects" so they can focus on this small set rather than searching and sorting through the master list.
Multiple users can select the same Project.
How can I achieve this in FMP 10?
(Is there a way to have a field's contents differ based on the current user? If so, I would just make a field called ViewInMyList in the Projects table.)
Does this make sense?