Forum Discussion
ArcGIS maps not communicating
Community Championhow 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?
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.
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.