Value List Based on Groups, Is it Possible?

[Dominic Filteau]

Hi all.

Using FMP 6

I'm trying to have a field that detects the Group the password is attached to

make a value list show only the options i want this group of users see..

This Value list will be chosen/edited upon opening the database, since it's password based.

so here where i got so far:

1-I have a value list containing all the availables options(for the admin group)

Those values are as follow: CAP;CAB;BOR;SAR;INT

2-I have a calculation field that detects the group using the "Status(currentGroups)" Function.Named Group Detect

So What I want to do:

If group detect = "group1" then make the value list show all possibilities

If group detect = "group2" Value list shows BOTH CAP and CAB(and still be selecteable)

if group detect = "group3" value list shows only SAR

If group detect = 'group4" value list shows only BOR

if group detect = "group5" Value list shows only INT

What is the best way to do so?

Creating different value lists and calling them upon detection

or even bettet(if i want to add a group later on and simply update the main value list and the script) Have the value list shows only the values i want..

The databases already exists where all users have a different browsing file with the value blocked to each user's file, i want to merge all those files to avoid having to update all clients files.

Please Help..