Problem with lookup database
I have two lookup databases. One for city codes and one for county codes. When I enter the name of a city in a text field, the city and county codes should appear in the proper areas. This is a recent problem. When I enter new information into the database and leave, there seems to be no prolems. However, If I sort it, as to put in alphabetical order, the information is no longer found.
This is a new one on me. I have been doing this for years. Anyone have any ideas.
Please describe the design of your database tables and layouts in more detail.
The only thing I can suggest from what you have posted so far is to check the types specified for you fields to make sure that you do not have a number field being used to store text.