InfoPath Dev

I have 6 different departments and all of them have a different department budget. I'm storing their budget information in a database. How do I query just for one department and add that department budget up when a user openings up a form. Example....

the user clicks a drop down box that says: Application Department

but I have 6 other department in the same database and their monthly budget report. How and where do I write a query statement to query just that department and sum up all of its previous budget data for that year.

Hi Michael,

You could add an OnAfterChange event handler (code) that gets called when they select the department. Or, you could add a rule that fires when a value changes and the rule could query the database based on the value. This is tricky and will require some hardcoding because the query strings don't support passing parameters.

The other possibility is to use our Database Accelerator Suite which will allow you to do this without writing any code.

Good luck!

How much does the Database Accelerator Suite cost?

Patrick,

I tried a rule, but I couldn't figure it out. Could you get me started?

Patrick,
What type of code will I have to enter in the OnAfterChange event handler.....I guess VBScript or VB.net.....help please