InfoPath Dev

In Infopath 2007, linked to a Sharepoint 3.0 list, I am trying to create an order form using the SP as the "catalog" of items where a user can simply put in a quantity and submit their order (this if for internal use).  I am scratching my head trying to make this work with a repeating table...   I can create the ...

Dustin, I think you are suggesting that I add a field to the repeating table?  The only issue is, this form is a database template, so the fields are locked, I can't add fields to the repeating table.  If I try to insert a field outside of the repeating table, it doesn't repeat :(

The easiest way I have found to do this is to: Create the text box field (assuming you want it displayed on the form, put it near the drop down list) If you want to display a mesage in the text box:  Create a rule on the drop down list so that if the value = new, set field value (the field you created above) to your message.  For ...

I am working on an InfoPath 2007 form with a repeating table pulled from SQL.  What I need to do is send an e-mail for each line that comes back from the query.  I copied the repeating table lower in the form into a repeating section (where I will put my e-mail information), but I am clueless how to filter the repeating ...

Thanks for the response, Ernesto.  We only want the users to read the table.  The "opportunity" of using a regular form with a database connection is the amount of time it takes for the form to pull in all the data, then filter.  Using the database-bound template, the query is much faster, but I agree is limited in scope ...

I am using a database connection (database template) to get all the asset records from an SQL table based on the user ID.  The problem I am having is trying to add a field to the repeating table (not from the SQL source) so the end user can update the budget code.  We do not want them writing directly to SQL, but to submit this data ...

I have been working on an InfoPath form with a connection to SQL server.  The standard SQL button options have the ability to create a new record.  Great feature, but how do I add that to custom code?  My submit button is doing a lot of stuff (like hiding sections, showing sections, sending e-mail, etc...) but I would also like to ...

Kalp/Martijn.  you do not need to have web services installed to connect an Infopath form to SQL server.  When you create the form, you have an option to connect to an SQL server (open Infopath, Design a from Template, Database, then select your database).  This will also create some custom action types (run query, new record, ...

I am trying to come up with a way to send some 3,000 e-mails internally every quarter to users who PC's are expiring on lease.  I have all the required data in SQL, what I would like to do is send them a customized e-mail with an Infopath form incorporated in the message (possible populate some of the InfoPath form fields with individual ...