While I don’t think I’ve entered bad data (after a career of database programming and maintenance), I am an old man. Okay, anything is possible.
So, saying that, and making the assumption that I might have actually previously entered New Orleans area data with a Missouri state, then you are intimating that is only in my data, maintained by the RM database program. If this is so, how do I access that data. I query locates for Missouri and only get back legitimate Missouri places. However, I am likely not querying a “place” table, but the place field found in my populated records.
The drop down list (so to speak) does fuzzy match to similar data and presents that to the user for a choice. Is that presented data in a “place” table. Most normalized databases save repetitive data in files and saves to your live record only a distinctive ID of the data that is actually, then and later, displayed. When the data is queried, it is made to return the full place data by using the ID lookup. I’m sorry, now I’m getting technical.
Basically, can I fix this?
David
Someone replied to your post.
| thejerrybryan
February 2 |
If I understand the question correctly, this issue has nothing to do with County Check or with Gazetteer or with whether the actual place exists in the real world or anything like that. There is not a built-in reference table of any sort that RM is using to pop-up the possible place suggestion.
Instead, if you are typing a place name into a new fact in RM, RM then tries to match what you are typing with places you have already entered into your RM database. That’s it, plain and simple. It doesn’t matter if the places you have typed in are correct or not. It doesn’t matter if County Check is turned on or not. The pop-up offering you places to use is offering you places from your own Place LIst. For example, if you have same named counties in different states, it’s likely first to offer you the county from the wrong state because it offers places is alphabetic order from what you have already typed. It becomes a more accurate guess by RM as you type in more letters.