Dwindling Value Lists

[MadDogMcree]

FMForum Members,

my apologys in advanced for possible spelling mistakes but my written english is not that good but here goes.....

I have a number of functions in a value list.

This value list is used as popup when a new volunteer is created.

When i create a Task i use the function value list to filter the volunteer list to set one or more volunteers on that task

Now my problem:

I woult like to see that when i choose a volunteer for a task that that name dissapeers from the list,

a so called dwindling value list

I konw that its possible i hav seen a number of examples but i cants figgure out how to make it work in my setup.

attached an example of my database.

Dropdown problem.zip

Can some on please help me, any help is appreciated.

With regards Robin

[comment]

I don't understand your setup. It shows a task may require several volunteers and - presumably - a volunteer can be assigned to more than one task? If so, you need a join table, say Assignments, between Tasks and Volunteers, instead of numbered fields Volunteer 1, Volunteer 2, etc. in the Tasks table - see:

http://www.fmforums.com/forum/showpost.php?post/246136/

The other thing that's not clear is the role of the Function field in the Tasks table: is it only to narrow the selection of volunteers? If so, I believe it should be a global field.

[MadDogMcree]

The idea is this, i want to use the database to manage volunteers and children that participate in an build week for kids.

There are several tasks that need to be divided between the volunteers, some tasks must be handled by the organization example getting the permits etc. but other things like the PR can be handled by the Interns, and the lifting / logistics etc. can be handled by anyone.

So the Function field is used to filter the volunteer list, if i set it to global i can only add tasks to say the interns.

The example is a functioning part of the database the only thing it wont do is dwindle. to bad that the whole database is in dutch other wise I could send it here.

Maybe the join table could work but I don't know how to do that, the example file took about 3 weeks to get that part working.

My biggest problem is that most of the manuals that I found are in English and as a novice I realy cant get my head around the whole join tables, one to many, one to one relationships.

Hope this answers your questions.

[comment]

So the Function field is used to filter the volunteer list, if i set it to global i can only add tasks to say the interns.

I don't think so.

In any case, I am afraid I cannot help you in the current state of your file - i.e. without a join table. I suggest you make an effort to add it, since with your current structure you are likely to run into problems much more serious that a dwindling value list.