ArcGIS maps not communicating

[salman_ali]

I have two maps that are on the same tab.  They both have same Customers across the country with exact same Lat and long from the same source. 

I noticed this morning that when I click on one bubble in one map, it doesn't pick up the same customer on the other map.  It would pick up some other customer in some other geographic area?

what could be the reason?

[v-xiaotang]

Hi @salman_ali 

Thanks for reaching out to us.

Not sure what you put in the Map visual and what's the relationship between the tables. Did you notice this morning? Was it working fine before?

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly

[vanessafvg]

how is your data related?  its mostly likely to do with how you have set up your model, the relationships between the tables, can you share?

[salman_ali]

I looked at the relationship.  It seems fine.  Each of the two maps have two tables that are both joined by Customer number.  Lat and long are coming from only one of these two table in each map.

So it makes no sense to me

[vanessafvg]

it seems fine but if you post the screen shot of the relationship i am very sure i will find the likely cultprit. 

[salman_ali]

Sure

also lat and long are coming from 

[vanessafvg]

what measures are you using  on each map?  what sort of information are you trying to show.     bi directional relationships can be dangerous and can return ambigious results.      You are joining on location, not on customer so this relationship  between the tables will not guarantee consistent results.    Ideally a star schema model is always best, which is your categorical data in look up tables and the transactional data holds foreign  keys from each look up table.   

if you explain what you trying to show on each map and what table it is coming from, then it will give me an idea of how to model this data.

if you able to share the data in text format that would be more ideal.