Two questions about InfoPath designing.

[Martin Vrkljan]

1. I browsed through the sample forms that come with InfoPath and I saw
something that I liked in the Invoice (Single Tax Rate) form; In the table
where the user can insert multiple items and include the item’s name, price,
quantity and to check the “taxable†box there is an field called “ItemNumberâ€
which automatically inserts the number of item in the column. I was trying to
make something like that myself in a new repeating table using
formulas/functions, but I had no luck finding a formula that would do the
job. Can you point to the formula or send a brief tutorial of how to do that?
2. I was trying out the possibility to use data from other sources
(Microsoft Access in this case, I made a small table with information about
Person Contacts) and I managed to insert that data in my InfoPath form by
receiving that data from the second source. I was wandering if I can do the
vice versa, to input data into a repeating table in InfoPath (a list of my
Contacts, for an example) and then automatically store it in a database?

Thank you,

Regards,

Martin Vrkljan

 

[Scott L. Heim [MSFT]]

Hi Martin,

Let me try and address each individually:

#1: How you accomplish this will depend a lot on how you design your form.
Will you be creating your InfoPath solution by choosing "New Blank Form"
and then dragging and dropping controls or will be you creating a form
"from a data source" (such as Access, SQL Server or Web Service?)

#2: Retrieving and updating data from a database with InfoPath is easily
accomplished; however, you will want to build your InfoPath solution "from"
a pre-existing database structure. InfoPath does not have the ability to
take a design you have created from a new, blank form and "submit" this to
some database to create the structure.

I hope this helps!

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Martin Vrkljan]

Thank you for your response Scott,

Yes, I got the answer to my second question. Thanks for that.
As for the first question, I just want to make a simple list of items from a
blank form using controls and I want to make it easier to fill with putting
automatic item numbering. Is it possible to do it that way?

Martin Vrkljan

 

[Scott L. Heim [MSFT]]

Hi Martin,

Thank you for the clarification - take a look at the following information
on InfoPath Dev (Greg Collins) as it should take care of what you need:

http://www.infopathdev.com/downloads/free/default.aspx?i=cd6b81a217de40a1b24
9ab42fcff0216

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.