InfoPath Dev

I am appending records to an SQL Server 2000 database using InfoPath 2007.  I made a trigger on the table the form is based on but when I append a new record the trigger never fires.  The trigger works fine if I append a new record using Query Analyzer.

I first assumed it just would not work due to some limitation of InfoPath but I've found references to people using trigger (successfully) but no help on why one would not work at all.  There is no error message and the data is appended to the table but the trigger seems to be asleep.

 Any ideas please.

Thanks

8/15

An update - The trigger actually worked once.  I had given up and I was going to try to find a way to do what I needed with out using a trigger.  When I first tried the new form and submitted it the trigger worked and did what it was supposed to do.  I then removed some of the fields from the from the form and tried again and the trigger went back on strike.  I put the fields back and it still won't work.  It did once so that's a little better - But why???

Does it matter if all of the fields are completed?

Does InfoPath only submit a partial record or leave some blank? I would try some testing with that.

 As far as I can tell it does a complete insert of all the fields I ask it to.  Some are null but I left them that way.  I have tried it different ways and the one time it did work I think I did fill in all fields, but I haven't been able to get it to work again all fields or no.

Thanks