I have four lists as explained below
EmpMaster ( Empcode, EmpName, BranchCode )
BranchMaster ( BranchCode, BranchName, BranchHead, ZoneCode)
ZoneMaster ( ZoneCode, ZoneName, ZonalHead)
ExpenseDeatils( EmpCode, Amount)
Now I want to join such a way that, if current user is Zonal head then he must be able to see all employee expense details comes under his zone.?
Case (1): suppose all lists exists on single site.
Case (2): suppose all master lists (empmaster, branch master, zonemaster) are in parent site and I have another sub site on which I have Expense Details list.