Privileges based on data
I am using Filemaker 10 on mac OS 10.5.8
I am a beginner to intermediate user of the software and I have a question about privilege sets.
Here is the situation: I have a database where I store tourdates, show info, as well as a ton of other information for several bands on the record label that I work for. The problem is, I want certain users to be able to see the data that pertains only to their band.
For Instance, Band A can only access the records that have the "Band A" selected in a drop down menu field. And cannot see any other records that have Band B or Band C chosen. Is there any way to manipulate the privilege sets so that they can be based on the data in a specific field? Am I going about this in the wrong way?
I know I could make a totally different database for the each band, but I'm not certain that that is what I want to do seeing as this database is related to several other databases I have created. Please let me know how I should be thinking about this if I am incorrect.