InfoPath Dev

I found a fantastic sample here. Be sure to read the comments below the sample, since there were some issues / fixes. Basically, you'll need to add a reference to Microsoft.Office.Interop.Outlook to your project. Here is a little more info on how to do that. It's under the COM tab. Adding a using statement to the top of the code should ...

You can autopopulate a text box, too. For example, if you had a field called 'Area' and a data source that related areas to quantities, you could set a rule on your areas field to fill the Quantities field based on the selected area. While this blog post refers to a drop down list selection, the same logic would work with other controls.

If your room names and areas change often, you might find it easier to use a database like Access or SQL Express (which is the free version of SQL from Microsoft -- I like it better than Access). If they are pretty static, you can either type in manually the entries for a drop down list control, or create xml files that you can use as a secondary ...

You'll have to remind me again of your preferred object model -- are you using 2003 or 2007?

Here is a great KB article on extending schemas....

If both buttons are set to have an action of Submit then they will both do whatever your Submit Options are set to. Instead, have one of your buttons use Rules and Custom Code for its actions. Then, for the rule, add an action. Select Submit using a data connection and then select the data connection....

Yes, please do send screen shots. I want to be sure you have foreign keys set for your child tables... :)

I am so happy you have been able to track it down! You have different options with this. You could use rules for submit (that should be an option in your submit options) and first add an action to submit to the DB, then to submit using your email connection. If you only want your users to email, and you want to submit to the db yourself, you ...

Well, mind you, I was just trying this by editing the SQL in a data connection in the data connection wizard... and then again in a direct query. Can't imagine why it would work differently in code, though. I'm assuming when you test the two different query strings, you are using the same parameters for {0}, year & month.... :)

Well, if your relationship in your database is a one - to - many, you *should* be able to submit. That's why I keep trying to figure out why you can't. Your main table needs to have a primary key. Your child tables need to have a column that holds that primary key. Your InfoPath data connection needs to have that relationship defined (you ...