Search Problems

[James Maxwell]

I built a database for a cd collection at a radio
station. It composed of entering data such as CD title,
song title, cut number, length etc. The queries include
artist search, song title, song year and song length. I
made sure everything worked. I made sure I can search for
those criteria. I used the wildcard * as well. The radio
station entered about 10 cds worth of information
according to them, and now the only thing they can search
for is song length. They got no errors or messages. As far
as I know no parameters or limitations on how much data
can be enter was set. What could be the problem.
Thanks
James Maxwell

 

[Albert D. Kallal]

My car is broken.

The above is not much to go on is it?

Have you tried the database that they have? How are they typing in the
search?

Perhaps they assume that for someone called Elton John, that they can type
in John, and get all matches.

I assume you are looking at them as they are using this? Have they been
trained to use the product?

I would think for a user friendly product you should built a nice search
screen. Most, if not all of my search routines are partial match, and the
user does NOT have learn to type in "*" or other strange characters.

Here is a few screen shots of a search screen of mine.:

http://www.attcanada.net/~kallal.msn/Search/index.html