Making an Invoice with value lookups

jfdicurt — Tue, 28 Feb 2006 16:08:23 GMT

Hello
I am having some difficulty making InfoPath create a simple invoice form that works similar to a Quickbooks or Peachtree invoice where I select an item from a drop down and the unit price is populated automatically via a filtered lookup.
To be more specific:
I have a Repeating Table that contains fields for Quantity, Description, Unit Price and Extended Price (Extended price is just Qty * Unit Price)
The Description is a drop down menu populated from a secondary data source.
My goal is to select the item in the desciption field and have the unit price complete automatically based on what was selected in the description field. The unit price value will come from the same secondary data source and same record as the description came from.

I have used the suggested default value formula for the unit price field where it performs a filter that matches the description the user selects with the description in the secondary data source:
@Retail[@Description = descriptionMRC]
Retail is the unit price I am looking up from the secondary source when the local description matches the description in the secondary data source.

It all works fine on the first line of the repeating table, but as I add lines to the table it no longer looks up the unit price correctly.
Help!

Thanks much!

General

Making an Invoice with value lookups