girish_327
Posts: 108
|
| Posted: 11/04/2006, 7:29 AM |
|
Hello Friends,
Please Help Me out in this Problem. I am validating Duplicate FIeld on Three Fields
below is Validation Code I am using on OnValidate Event
Dim ClubNo, MonthID, YearID
ClubNo = CCDLookup("Club_No","Activity","Member_ID=" & CCGetUserID(), DBLions)
MonthID = CCDLookup("Month_ID","Activity","Member_ID=" & CCGetUserID(), DBLions)
YearID = CCDLookup("Year_ID","Activity","Member_ID=" & CCGetUserID(), DBLions)
If (Activity.Club_No.value = ClubNo AND Activity.Month_ID.Value = MonthID AND Activity.Year_ID.Value = YearID) Then
Activity.Errors.AddError("You Already Sent this Month Report.")
End if
It is working when there is Not a Lots of Records but after 100 of records Its not Validating and Accept the duplicate Data. Please tell me what I do.
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
