DVLs I'm Stumped!

[thegamechanger]

Hey there, 

I'm sure others have come across this issue and I've even done some extensive research prior to asking for help.

I have an employee database set up and I'm attempting to set up a scheduling module.   I'm no stranger to conditional value lists, but this has me stumped.

In my parent table I have my employee details (including job types and classifications).  In my child table I have all the necessary scheduling info.

I currently have a conditional value list that allows me to pick employees based on job type and classification.  Since employees can be booked on various jobs at different sites, I need to add a date filter to keep folks already booked that day off my list.  I created a dvl_key in my Employee Table (which lists every date that employee is booked).   When I try to add the relationship Employee:dvl_Key ≠ Job:Date to the parent to child relationship It kills my value list and my relationship altogether . 

I've tried everything I can think of and even addressed the attached file. 

What am I doing wrong!?!?!?!

 

Adventure 1 CVLs.fmp12