kendra M
|
| Posted: 06/17/2004, 8:50 AM |
|
CC - Check if exists before insert
FOund this on Old Forum, I need to do the same thing but in .ASP. anybody have any clues, Thanks
Author Nicole
Date Created 5/7/2002 5:01:10 AM
Message Vince,
create Validation event and use lets say dlookup function to find if the record exists, e.g.:
$exist = dLookUP("table_name", "count(*)", "code_field_name = ". ToSQL(get_param(entered_code_field_name), "Number");
if ($exists < 1)
sFormNameErr .="In valid code <br>";
If no records exist user will get error message.
Then select 'Create Validation Rule' flag on form properties to make event work.
|
