I have a dashboard where we have two major tables :
Vacancies and Assignments
We are facing data issue when putting the security on the two tables because not all the vacancies have assignments so the security on the vacancy table is removing all the data not found in the assignment table (Vacancy ID is the key between the two tables)
If we remove the security on the vacancy we have the data.
we tried to make left join on the assignment table but still not working.
N.B : if we remove the section access the relation and the data is correct but when working with security there is data missing.