Newbies MadDogMcree Posted April 1, 2012 Newbies Posted April 1, 2012 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
imoree Posted April 1, 2012 Posted April 1, 2012 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
Recommended Posts
This topic is 4639 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now