We have extended the meta data model to have a lot of custom meta data. Two of these fields are Location - which is a category selection popup box. This is a very strict location list according to a gazzateer.
The other is Alt location, which is for all other spellings of the place name or historical names. There are a lot of these are most places have bilingual names.
In our current database we have matched just about every single Alt location to a specific name in the gazateer. So what I would like to do, is when someone selects the location, it either auto fills or auto suggests all the possible alt locations when you get to that input box.
Has anyone done anything like this before, or can anyone think of a fairly simple way to do this?
We are using Enterprise 3.2.
Paul