I am having trouble to display data from different data types, that are actually linked to each other. Below, I explain what is going on:
There is a data type named POSITIONS, which contains job vacancies. For each job vacancy, there’s a list of persons. Each person is added to the data type CANDIDATES.
Each job vacancy has a GENERAL CODE as a field. Likewise, each person has an assigned GENERAL CODE as a field, depending on the job vacancy he/she has applied to.
I am displaying in one page a list of job vacancies in a repeating group. In this repeating group I added a button to open a popup that should show the list of persons that have applied to the corresponding job vacancy.
So far, I only managed to display EVERY person that was added to the database, regardless of the job vacancy the person has applied to. However, as stated above, I would like to display ONLY the persons who have applied to the corresponding job vacancy.
I appreciate any help!