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.