Associating fields

how can i associate one data field with another. for example i have a city field that i want to associate to a country field so that i don’t get absurd queries like New York in in Africa or something