AnsweredAssumed Answered

Privileges based on data

Question asked by precociousninja on Jun 3, 2010
Latest reply on Jun 24, 2010 by precociousninja


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.