Derek Brown
asked on
Duplicates Check
What is the best way to check for duplicates in a form based on a select query
I have a continuous form where users enter information (a list of numbers). When the list is so long that it goes off the page it would be nice if rather than check to see if they already have the next entry in the list that the program gives message "You already have that number listed." I cannot use the tables no duplicates as the table holds data for a number of lists and will need to store duplicates.
I have a continuous form where users enter information (a list of numbers). When the list is so long that it goes off the page it would be nice if rather than check to see if they already have the next entry in the list that the program gives message "You already have that number listed." I cannot use the tables no duplicates as the table holds data for a number of lists and will need to store duplicates.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both
Open in new window
The above assumes the field we are checking is numeric. If it is text, rewrite line 4 like this:
Open in new window