1 Reply Latest reply on Mar 8, 2012 10:49 AM by philmodjunk

Problem with lookup database

JamesRyel Mar 7, 2012 9:50 PM

Title

Post

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.

Thank you.

1. Re: Problem with lookup database

philmodjunk Mar 8, 2012 10:49 AM (in response to JamesRyel)

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.
Like Show 0 Likes(0)

Actions