InfoPath Dev

Description: I need to create a form to order office supplies.

Fields:

1. Product name ,
   
2. Product code,
3. quantity
4. Gross unit price
5. Value (unit price * quantity)

My questions: What should be done to:

1.  After selecting the field PRODUCT uploaded other info to other fields (such as unit price, product code,  etc.). [Should I use filters and if so how to do it]
2. to count unit price * quantity in Value field
3. To counted 10 items, and gave the sum of the final contract (with the few fields of Value field)

Thank you in advance for helping.

 You should provide a dropdown box that displays the product names but actually stores a product code. Then display the actual value of that field in an expression box next to the dropdown.

 That takes care of 1 and 2.  3 a textbox for the user to edit.  4 should be a field with the default value referencing the unit price in your DB data source and filtered using the product code in 1 & 2.  Then use a simple multiplication expression (my:quantity * my:unitPrice) as the default value for the value field.

You can use the sum() function to get the sum of all of the instances of a single field across repeating sections.

I managed to do most things. But i still have some questions.

1. I have a table with fields

•  Product: this field has two rules for fields code and Price - which fill up automatically (yupi :) )
• Category:
  
• Code: filled in automatically
  
• Quantity
• Price: filled in automatically
  
• Value: cunts: Quantity*Price

I would like to have a filter box category, which when I select a field "category" for example PEN show me all the pens in the box product.

And next question: is there a way not to do a few items I mean not to establish that the position will be 10 only, but  if user want to do " next field" and all rule of doubling and then at the end of the order value of the count of selected items (something like repeating table - but i dont know how to use it)

yes, you can do that with rules and xpath functions