InfoPath Dev

I am trying to insert data into sql table using Infopath 2007. Can I use composite keys in database? As soon as I create composite key and refresh connection in Infopath, submit is disabled. Does anyone have some expirince about this problem.   Thank you.  

 Dear All,   I use Infopath 2007 and forms based on sql 2005 tables.  What I would like to do is, to print only one record per page (f.e. I have table with Products and their specifications, and I would like that each record would be on new page). Thanks for any sugestions.

Hi, I am using the triger and it all works fine. It fires on the "UPDATE/INSERT" event... Do you have some master - detail tables? There could also be problem with primary key (a don't see any problems if you use identity option in the sql table - otherwise you have to somehowe provide primary key...  - Marko

Dear all,   first of all, gratulations on great forum you have, with some great stuff.  I need a help with search in infopath 2007. I have a form that is based on the sql table and using standard search provided in infopath. When I wan't to search for information that is based on text field (varchar...) it won't give any ...