Filter on ArcGIS map

[przemek_pbi]

Hi All,

I've got 3 recordsets: Sales, Purchases and CustSupp. Sales is related to CustSupp by customer/supplier field and Purchases is related to CustSupp by customer/supplier field. CustSupp contains roughly 500 customers and 2000+ suppliers. I want to show Sales  customers data on ArcGIS map but the map tries to show all records from CustSupp recordset (both customers and suppliers) even though I've created an element filter saying that Sales should not be empty which brings the problem with 1.500 record limit for free version of ArcGIS map. I don't want to move customers to Sales recordset because the actual report contains far more recordsets where CustSupp is related to.

Any idea how to solve the problem?

Regards,

Przemek

[v-yulgu-msft]

Hi @przemek_pbi,

In my test, the ArcGIS map can be filtered by its related table/fields. Would you please provide more description and some sample data so that I can reproduce your scenario on my side.

Regards,

Yuliana Gu