Conditional Value Lists using Repeating Fields
I have developed conditional value fields in the past, and have been able to eventually make them work. Now, I'm working with repeating fields and there's a problem I can't seem to work out...
I am developing a budget package... Staff are listed in departments (DEPT Code) and Job Description (JOB Code). Each staff therefore has a DEPTJOB concatenated code assigned to them. In a related table, I have assigned the Department Code and Job Description code. I want the User to be able to select only those individuals that correspond to the concatenated DEPTJOB code, through a conditional value list.
Problem is, the DEPTJOB code field is a repeating field. The resulting drop down field includes all individuals from all DEPTJOB combinations for that record...