InfoPath Dev

I want to use InfoPath as a Form to capture data, saving it to the database WITHOUT managed code. The database uses one-to-many realtionship tables. Once I have conneted to my Access DB, I am able to ADD TABLES using the wizard, associating them much like they are associated in ACCESS, but as soon as InfoPath suspects a one-to-many realtionship - it disables SUMBIT.

Can InfoPath do what I want? Or is this more complex and requires code.

You might try the IP2007 beta. I believe it has better data base support.

But in general the one-to-many kills submit for DB in IP2003. A Web service would be required in this case.

what do you mean, one-to-many relationships kill the data connection? I have 40+ tables in my main connection and it works fine.

Not the data connnection -- the submit.

My mistake from earlier. It is many-to-one relationships that IP2003 doesn't like. It should be fine with one-to-many.