Hi
I have a form with unbounded text boxes where a user enters payment details. When he clicks "Submit" I want to scan the table where payment details are stored to see if a duplicate payment had already been made in the past, before I enter this new entry.
How can I do a scan of the table to see if a duplicate entry exists? I have looked at RunSQL but I don't think it returns a value.
Thanks!