as shown in the attached picture the two tables are linked by Vacancy ID.
If we generate the vacancy table alone we have for example vacancy id : 3060
while this vacancy doesn't have a row in the assignment table.
when we reload the assignment table the vacancy id 3060 will not show.
I have tried the outer join , join and now as shown in the attached pic i tried not to join the two tables, leave them separate and linked with a unique key field (vacancy id) but no solution till now.
we found now that the problem is from the section access security because we are making the security on a field found in the assignment table and in this case the field will be null if no assignment then the record is removed :S and we need to do the security in such way.