Forcing users to input data

I don't see what the question has to do with "General database discussion", or even with databases. Looks like you will do better in the appropriate forum for your front-end language. The actual db query will just need to query against the given ID, and use the count of the returned rows to provide an error message.
I notice from your profile that you have asked 15 questions, but have not marked any of the answers as being valuable to you. If you haven't had valuable answers, read faq222-2244 carefully to get ideas about how to ask better questions.
If you have had valuable answers, please read faq222-2244 carefully to see how to mark those answers as valuable. This not only lets the responder know that their time has not been wasted, but also marks the thread for other users.
The FAQ also gives guidance on general forum usage, as I also notice that you haven't yet provided any answers to any one else's questions.

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

I would agree with the above post.

To answer the question, if this is for a Web application then Javascript verification ought to to do the trick.


If it is a standalone (Access data scree, for example) you would need to script it there.

Make ID number a drop-down field to the user, limited only to the choices in the drop-down.

hdingman, that could be either a very good idea or a very bad idea. If the OP's app has ten ID numbers, it's a good idea. If he has a thousand ID numbers, that would kind of suck.

Hi,

Thanks every one for your input, I was able to resolve the problem.





Regards,

OCM