InfoPath Dev

I am trying to use custom code on a button to change the value of one field in every row of my table from Yes to No.  Has anyone tried this?

Here's what I have so far: I have 1 view that I run a query with, the results appear in a repeating table below the query with only 4 fields showing and a button to swith to the full details for that record which is another view. I have a button that I want to use to open another view with all the fields blank so that the user can enter new ...

I have a form with multiple views set up.  The view that I want to add new records with works fine if I don't query the DB first.  All the fields show up as blank and I can enter in data.  The problem is, if I run a query first, then try to go to the view to enter a new record, the view is populated with the results from the ...

I am not very good with coding, but I was wondering how would this work with a record in a SQL DB?  And exactly how would that code look?  Thanks for any help with this.  

Thanks for the idea, but in my case, the number is generated prior to being input into the form. That is why I want to have it checked against the database, in case someone ''fat-fingers'' the entry and accidentally enters a duplicate number in. Right now, SQL kills it after the submit button is pressed, but I would like to have the error found ...

I'm sure its been asked before, but I can't find it here. What I have is a SQL 2000 DB with a single table. I have a form made for the initial entry of data into the DB. The first field on this form is also my Primary key and is unique to every row. I am using the Data validation to ensure the format of this field is correct and that part ...

Here's what I'm trying to do: I have a DB with one table that I want to have a Query of only a few fields that will show the results in a different view much like the Master view is set up. (I refer the the excellent How to on this site). I then want to be able to select a record to view in a new Detail view (Again, as referenced in the How to ...