almost dwindling value list

[MadDogMcree]

Maybe someone can help me I just cant seem to get it right,

I set up a database of volunteers witch I can assign a task using a portal and a dwindling value list, I got that part to work.

But then I found out that the dwindling part only works on one record so I changed a couple of things,

1. I set up a self join relationship to keep a list of all volunteer keys used in the join table across all records.

2. I changed the calculation use that self join relationship.

The one thing I cant seem to get working at least fully is when I select a volunteer in the portal in record one in it displays a

list of all of the volunteers (so far so good) after I assign four I create a second record.

When I open the list it shows all the volunteer names including the previous four, but when I select the first one and change it

the list suddenly updates to omit the previous four.

the same happens with record three four five......

I want it to work like this: once a volunteer is selected or a task it removes him from the dwindling list, when I create another task

I want it to use the same list excluding all assigned volunteers in previous tasks.

It must be something simple but I cant figure it out.

I'm using filemaker 11 pro advanced.

Any help would be appriciated.

Testing.zip

[comment]

Does this work all right for you?

Testing2.zip

[imoree]

Funny thing was i was just trying to do a simple test myself.

Do you have to have an "ESTABLISHED JOIN TABLE" in order to dwindle the list?

eg

do we need this relationship first;

task_volunteer -> JOIN <--Volunteer

& once that is established , we can then do the

task_volunteer ≠ Volunteer

that would be very nice ..

Also , can you not also use a calculation in cVoluntteer to be just

list( Volunteer) & "¶"

-thanks