Re: How to verify if the current value entering exists on the database

[Jerry Piland]

** Addis,   Have you started full-time with Compucom yet?  Just happened to see your name come across the ARSlist, thought I’d check on you.   Jerry Piland Senior Recruiter PALADIN Consulting, Inc. 3030 LBJ Freeway, Suite 1140 Dallas, Texas 75234 Main - 972-783-1995 Direct - 214-254-3948 Cell - 214-802-3231 Toll Free - 877-783-1995 email - [EMAIL PROTECTED]   We offer benefits to Paladin Consultants, Medical, Dental, 401, LTD, STD, Vision, Life, AD&D etc.  Did you know! PALADIN pays referral bonuses for your referrals - contact us for details!   Visit our website at WWW.PALADIN-INC.COM to see our Current opportunities available. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Addis Solomon Sent: Monday, August 28, 2006 10:43 AM To: arslist@ARSLIST.ORG Subject: Re: How to verify if the current value entering exists on the database   ** Kelly, I followed instruction # 2 however, the lastcount is counting all the records that are on the form instead of only  values that matched the current value.  Any recommendation? Kelly Deaver <[EMAIL PROTECTED]> wrote: ** There are several ways, depending on what you are trying to accomplish. I'm going to call the field you are interested in FieldA in my examples.   1. If you are trying to assure that no two records have the same value in a particular field (FieldA), create a unique index for that field. In the Admin tool, open the form and select form>form properties. On the Index tab, move the desired field to the right column and check the "unique" box below. Save. When the user submits a new record, it will say that entry violates a unique ID on FieldA.   2. Add a field, FieldB, to number field to check the result of an active link you are going to create.Create an active link that runs on loose focus, run if - FieldA != Null. Select a set field of the field action. Query the form name of the same form (not CURRENT SCREEN) where $FieldA$ = 'FieldA'. Set the no match = set the field to null. Set multiple match = Use first matching request. Set Field - FieldB = $LASTCOUNT$. This will tell you how many already submitted records match the current value in FieldA. You can then create an error message if FieldB not NULL that tells the user in more detail what you want them to change.   3. Do the same thing with a filter to check on submit and block the submit action if you like.   4. If you aren't trying to block, but rather find matches, you can do the same as #2 except instead of setting multiple match to Display a List. --------------------- Kelly Deaver Director, ITSM Practice Xinify [EMAIL PROTECTED]   -------- Original Message -------- Subject: How to verify if the current value entering exists on the database From: Addis Solomon <[EMAIL PROTECTED]> Date: Sun, August 27, 2006 12:27 pm To: arslist@ARSLIST.ORG ** Can anybody help me how can I check if the current value entering already exists on the database?   Thanks in advance for your help All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___     Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___