Hi,

I got this nice solution from LaRetta for which I am very grateful, but I
discovered a nasty habbit of FM in this particular case. I have several
users and each user is member of one or more groups. When a user has to
select a group from the pull down list (or radio buttons or check boxes)
only those group members must be shown of which the user is participating
in. The problem now is that FM keeps showing ALL the group members in the
collection and not only the groups the user is a members of. Thus the user
can select a group in which he doesn't participate and the result is that
the fields contains <No Access>.

I tried to use a global field for the pull down list but FM want to index
the field. So I keep the problem that I want to populate a field with only
those groups the user is a member of and not the whole collection.

Has anyone an idea?

Thanks,

Marcel
> Create a calculation (text, index ON) with:
> Status( CurrentGroups)
>
> Then create your VL using 'values from field' and point to this calc.
> Format your field as radio using this new VL. Since
> Status(CurrentGroups) does not apply to only one record (it depends only
> upon the User), it will always display only the groups associated with
> that User.
>
> Cheers!
>
> LaRetta