InfoPath Dev

I am designing a simple form in InfoPath 2007, connected to a SQL database. The form has two fields: one is PartNumber, the other is PartDescription. I added a rule so that when the PartNumber matches one in the database, the PartDescription will fill in automatically.

 The rule looks like this:

Set a field's value: PartDescription = @Description [PartNumber=@StockCode].

 When I fill out the form though, the rule doesn't work. There isn't an error message or anything, the PartDescription field just doesn't fill in. Any suggestions?

Thanks.

I would do a dump of your secondary data source and check the data that is coming in.

1 make sure you are querying the dataconnection before you try to use it.

2 sometimes the SQL can have leading or trailing space or some other reason why the data match might not work.

Thanks, I got that working. Now I have another question...

I want to be able to fill in a partNumber (with the partDescription auto-filling), and then be able to modify the partNumber to one that isn't in the database without the partDescription changing.

So if I put in "SP0021-02" for the partNumber, the partDescription fills in as "CR16XX SD/HD/3GIG SW". Now I want to be able to update the partNumber to "SP0021-03" (which isn't in the database), without the partDescription changing at all.

Is that possible?

Thanks again for your quick response.  

Yes this is possible, you could add a condition to your rule which checks if the value is found in the secondary data and if so update but if not would fail.

One warning, I think you are trying to create a new record based on an existing record.

Unfortunately this will not work with the basic database connectivity.

You will end up updating the queried record, not creating a new one in your example above.

Just so you know.

That worked beautifully, thank you.

 And thanks for the tip--the form is meant to be printed out and given to the people who have the authority to change the database after they approve the change, so I think it will be ok.