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

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.

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