How can I check if a record exists before inserting
I need to check whether a record already exists with the same description as that in a form being submitted for insert by DataAssist and, if it does, don't insert and redirect.
Previously, I could have fudged it by using Dreamweaver's 'Check New Username' behaviour and substituting my description field for the behaviour's username.
I need to use the DataAssist insert record behaviour because I am also using Digital File Pro on the same page but Check New User Name doesn't work with DataAssist's insert record behaviour.
Is their an easy way to check if a record exists prior to insert using WebAssist's tools?