I know how to avoid duplicate records when using @dblookup with the client. How do you accomplish the same over the web with most of the validation code in javascript?
Thanks.
Subject: Avoid Duplicate Records over the web
One idea is to use a hidden (computed for display) field that generates the list you want to compare to. If the new value is in the list, the don’t allow it. Watch out though because your HTML page will be very large if you are not careful.
You could create an agent that will compare the value from the URL parameter to the list of values and return the result in a hidden frame (or other hidden window). The agent would be called via a JS event, then you’d read the results from the agent. Make sure the agent returns something unique you can test on.