如何在不知道城市/州的情况下将客户与国家联系起来

Suppose I have database tables called Customers, Countries, States and Cities. An individual customer would have a CityID field, which links to the Cities table. Each city would have a StateID field, which links to the states table, and similar for countries.Suppose I have database tables called Customers