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]> 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 ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

