Section Access Question

[LisaDrummond]

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

[jwjackso]

If the BILLGROUPID is zero when it doesn't a bill doesn't exist, you could add an additional row for each CLAIMGROUPID where the BILLGROUPID is zero.

ACCESS, USERID, CLAIMGROUPID, BILLGROUPID, OMIT

USER, TestDomain\TestUser ,123456, 123456

USER, TestDomain\TestUser ,123456, 0