InfoPath Dev

no, you do not need a trigger to update a record.  infopath should update the record automatically...  i use the trigger to create a log, and start procedures...

yes, i did get it figured out... it had to do with my automating of the email after the trigger.  i had to change the permissions of who was sending out the email to match the person who is writing the infopath form.

I am running into the same kind of problem.  i am running InfoPath 2007 and SQL 2008, my trigger works within SQL, but once i open the form and write to the table, the form says it submits correctly, but when i look up the SQL Table, nothing has been inserted???  any suggestions would be greatly appreciated.  -Patrick