Hello, I have a big lookup table that have the table , district, region and town, everything seems to work fine actually but, recently, we extended the table, and it happens that there are lot of town in different region that have same name, when I add the people referred to each town in the table, wont it appear in the two places with the same name?
That's a common problem - there are some good strategies for working around it. First off, I'd be sure to use a value that you're sure is unique whenever you're storing something like this (you can still show something different to the user). If you're using CommCare's Locations/Organizations feature, the site_code field is a good choice for this.
Now to remove the ambiguity when displaying these choices to the users you have a few options. One is to add another column to the table called display_name or something, where you add additional information where necessary to disambiguate (eg, instead of "Cambridge", you'd have "Cambridge (Massachusetts)"). Then you can make your lookup table questions display this field instead of just the town name.
Alternatively, you can use a drilldown selection. That is, first you'd have a question where the user chooses a region, then a second question where the user chooses a town. You can put a filter on the second question to only display towns in the selected region.
There should be some examples of this kind of thing on the help site.
I already found a way to solve it , I just added two state in the filter so that It will retrieve the one from the specified places.
Thanks a lot