I am using section access to control which Clients they are able to view data for. I put an example below that I need to handle for.
Claims - users can see based on Section Access column = CLAIMGROUPID
Bills - users can see based on Section Access column = BILLGROUPID
The CLAIMGROUPID value for Claim 123 = 123456; There's no Bill yet - so there's no value for BILLGROUPID.
The user is allowed to see all Claims with CLAIMGROUPID 123456, and all Bills with CLAIMGROUPID = 123456, but only the claims that are linked to a bill are showing for the user. I need all claims to show, regardless of if they have a bill.
How do I resolve this so that the user can see all claims, regardless of if they have a bill?
My section access looks like this.
ACCESS, USERID, CLAIMGROUPID, BILLGROUPID, OMIT
USER, TestDomain\TestUser ,123456, 123456
