Hi all

I'm new to this community. I have googled about my problem but couldn't find a working solution for my problem. I have these lists:

• A list of Sites (ID, Name): Dim_Sites
• A list of tanks (ID, Name, Site). Each tank belongs to exactly one site: Dim_Tanks
• A list of users, each of which having access to at least one site (Site, User): Dim_UserSiteAssignment
• A data entry form (Site, Tank, Onhand): Tank_Onhand

I want each user to have access only to tanks which they have access to their site, like this:

User A has access to site S1

User B has access to site S2

Tanks T1-T4 are in site S1

Tanks T5-T8 are in site S2

If user A is logged in, they should be able to select only T1-T4

If user B is logged in, they should be able to select only T5-T8

During my searches, I reached this link. I added Site field from Dim_UserSiteAssignment in Tank_Onhand list, so I can use this to cascade-filter available tanks, but I cannot select User field in this section:

When I open field selector, it only displays fields from Tank_Onhand list, not Dim_UserSiteAssignment list. How can I access the field I need?

Edit: I just noticed that "List column name" in upper section also comes from Tank_Onhand, not Dim_UserSiteAssignment!

Thanks in advance.