Do you mean you want to check the entire table/form? Using a filter (2 actually) is still a good approach. Basically, you add a display-only field to the form, upon submit (and perhaps update), you have a filter that runs a query (set fields to the new field you added) to see if there are already any other matching entries. Then the second fire would filter if the value of your new DO field has a value (that means a match was found and someone is trying to insert duplicate data), and you pop up an appropriate error message.
So, that validates new data coming into the system. If you want existing data validated, you'll need to run some DB queries to find the duplicates (it's a relatively simple SQL statement) and fix them. Then you know you've got good data to start with, and you ensure that new data is good also. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Oyefeso, Bola Sent: Tuesday, September 21, 2010 2:48 PM To: [email protected] Subject: Re: Unique Index ** The condition is only checking the request, but I want to check the entire database. Bola Oyefeso ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Tuesday, September 21, 2010 4:28 PM To: [email protected] Subject: Re: Unique Index ** Check for the condition using a filter and pop a message if the record already exists. On Tue, Sep 21, 2010 at 4:24 PM, Oyefeso, Bola <[email protected]<mailto:[email protected]>> wrote: ** I have a field that must have a unique data in the database but I don't want to use the unique index of the form because using the Unique index displays error that can confuse the users. Any idea out there? Bola Oyefeso _attend WWRUG10 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
