Out of range error when the trigger fires

[Sally Masipa]

I have a problem whenever I update data into my table tesiting the trigger below, it complains about the field in my log table AuditID --(not null , autonumber),

at first I didnt have it in my insert statement and it complained about data out of range and I tried to fake the field as '' in the below it still complains , Can anyone assist with this matter.



Create trigger log before update on tblName
for each row
insert into tblName values ('','Emplog','1',Current_user(),current_timestamp,new.FullName,old.FullName,'FullName','U');

-----




thanks in advance



Edited 1 time(s). Last edit at 12/23/2008 03:38AM by Sally Masipa.