Auto Suggest

[led123]

I am currently trying to add a section of code to auto suggest the next message code (taking the message last one in the database and suggesting the next one to the user) in the text box. Any suggestions?

[Steven J Jowett]

How are you presenting the suggested message to the end user?

Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

[led123]

In a text box on a pop up window.

[Steven J Jowett]

I would suggest that you need to store an Unique ID column next to each message within your database, or a column for the sequence, (which ever best suits your requirements), the store the last shown message Id somewhere. When you the want to show the next message : SELECT TOP 1 MessageText FROM MessageTable WHERE MessageId > LastMessageId

Steve Jowett ------------------------- Real programmers don't comment their code. If it was hard to write, it should be hard to read.

[led123]

We do not have the permissions to create new columns in the database. We have to go with the column message codes that is already in there.

[Drew Stegon]

IF there is not a field that you could use as a comparison, like an ID field, then you could open up the table, search the each record (do loop/for each) for matching text to the current message text and then move to the next record and display that. When you get to EOF, then just go to the first record and display that message. Long way around, but sometimes you are forced to do things in code you nromally would have to do because of bad database design.