0
votes

I have a query in which I select multiple values. The results are good except for one single column.In which I have a drop list with values that can be selected.

I managed to get the values but they are the same for each line, where they need to be different depending on an other column.

So I have the following table (The result of my selection Query).

enter image description here

The Column "Candidat Nom" (Far Right) is what I'm looking to adjust.

Further Explanation about it

This column as explained is a drop list

enter image description here

That contain values selected with the following query :

    SELECT T_SALARIE.SALARIE_nom & " " & T_SALARIE.SALARIE_prenom AS Expr1, T_ACTION.ACTION_identifiant_emploi
    FROM T_ACTION INNER JOIN 
(T_SALARIE INNER JOIN (T_SALARIE_EMPLOI LEFT JOIN T_STATUT_EMPLOI ON T_SALARIE_EMPLOI.SALARIE_EMPLOI_statut_id = T_STATUT_EMPLOI.STATUT_EMPLOI_id) 
ON T_SALARIE.SALARIE_NNI = T_SALARIE_EMPLOI.SALARIE_EMPLOI_salarie_nni) ON T_ACTION.ACTION_identifiant_emploi = T_SALARIE_EMPLOI.SALARIE_EMPLOI_emploi_identifiant
    WHERE (((T_STATUT_EMPLOI.STATUT_EMPLOI_statut) Like "*valid*" Or (T_STATUT_EMPLOI.STATUT_EMPLOI_statut) Like "*décidé*"));

What it's doing is select candidats that want to join an other job (jobs are determined with an ID). as we can see here each job (ID) have a certain candidat or candidats that want it.

enter image description here

The issue here is that each time I got the list of all candidats and not the list of candidats for a specific job.

What I want for Exemple :

For the first Line that represent a job and that have only two candidats, get these two candidats and not all candidats for all jobs.

I hope I was clear in explaining. If not please let me know so that I can add more details.

Thank you !