AnsweredAssumed Answered

Relationship Based Dynamic Value List Question

Question asked by smchampagne on Mar 20, 2018
Latest reply on Apr 9, 2018 by smchampagne

I know that this is pretty straight forward, but I think I've been staring at this issue too long. 


I know there are several threads on this & I have been browsing many of them, including the Adventures in CVL files posted by philmodjunk.


For some reason, I just can't seem to get the settings just right for this situation.


I have  Events, Personnel, and personnelEvents tables.


On the Event Details Layout, I want to have a dynamic value list of available personnel. 


Personnel are available if they are active personnel (boolean field on the Personnel Record) & they do not have an entry in the personnelEvents table that matches the Event date.


For some reason, I'm having a difficult time setting up the table occurrences to present this properly & I would appreciate any help you could provide.