InfoPath Dev

I am using basic functionality. But no, I have saved the record along with submitting it. So I open the record from the view of all saved records. It appears that this is where the problem is. If I query the record from the form, edit it, then submit it, it works. But if I open the record from the view, it doesn't work.

I have seen many posts related to this but not one specific to mine. If there is one I apologize for taking everyone's time. I have an SQL Server 2005 database with InfoPath 2007 SP 1. In the database I have one table (demographics) with a primary key that has a simple relationship to about 10 other tables. My InfoPath form has a ...

Great. I am new to using triggers. Do you have to use one when trying to update a record in SQL Server from an InfoPath form? I am able to insert a record but when I try modify the record it states that their is already a record with that primary key.

Patrick,  Did you ever get this figured out?  John

Did you mean that you 'have not' been able to connect? I have not been able to. I also have not found a walkthrough. I know you can do it through the Business Data Catalog but I don't control the server part of MOSS so it is difficult going for me.   John

Hello, Can you point me to instructions on how to query AD? I have only seen instructions on how to get AD information on the current user. I want to query the AD for a list of names. Thank you.   John

Hello, I am trying to create a data connection to an Oracle Operational data store to retrieve data, not submit. When I follow the directions to create a new data connection, an error message is returned indicating that I must use a SQL or Access database. Any help provided is appreciated.