AnsweredAssumed Answered

filter records available for a value list

Question asked by andypost on Dec 29, 2014
Latest reply on Dec 30, 2014 by Garryt

Hey Thrill seekers,

I'm trying to create a sign in sheet for our local Habitat Volunteers.  Let's say I've got three tables, Days, Volunteers, and LinkWorkers.

 

Days has Address and Date values that list what dates we are working on which houses.  We can have several houses running at the same time.

 

Volunteers has their names and contact poop.

 

LinkWorkers joins the two so someone can sign up for as many days as they are willing to work, God bless-em.

 

I've got a sign in sheet that lists the address, then a portal that shows records from LInkWorkers.  The Name fields is a value list that shows all the names from the volunteers table.  What I'm trying to do is remove names from the value list if they have already signed up for that day.

 

So if I've signed myself up to work on 1/1/15 at 1111first street, and someone wants to assign me to another house not realizing I've already signed up for a house my name will be removed from the value list.  BUT...it will be available for another date where I'm not signed up.

 

Does that make sense to ya'll and do you have any idea how to pull it off?

 

Thanks in advance for your expertise. 

Outcomes