Dynamical populating a list that can be used as drop down list

[Marcel]

Hi,

I have a solution in which a person can be a member of one or more groups.
In this case the groups are those used in the protection schema of
Filemaker. If a person is a member of more than one group I want these
groups listed in a drop down list or radio button field. At the time a
person want to make a new record this drop down list must appear in an other
layout where the person can choose a group name and the record that is made
is grouped under the group that is chosen.

I can get the groupnames where the user is a member of. But I can't get the
names in a value list. How do I put these group names in a drop down list?

Thanks,

Marcel Kollenaar

[LaRetta]

Hi 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


--
Posted via [url]http://dbforums.com[/url]

[Marcel]

Hi LaRetta,

Thanks, I implemented your solution immediately. It works Great. I thought I
had to use a construction much more complicated. This nice and simple and
I'm aware; I'm still not thinking the Filemaker way :-)

Marcel Kollenaar


"LaRetta" <member30258@dbforums.com> schreef in bericht
news:3358228.1063294887@dbforums.com...

>
> Hi 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
>
>
> --
> Posted via [url]http://dbforums.com[/url]