Lookup values in a secondary data source from a repeating table?

[Ed]

I have a repeating table for users to enter in items to purchase. They
select from a drop-down list box the item they want. The values in the drop
down box are retrieved from the seconday data source. Once the user selects
a item from the dd-box a rule is in place to set the product price by looking
it up in the secondary data source. The problem is that the price returned
is always the price of the first item found in the seconday data source for
any item in my repeating table.

secondary data source has records
1-1.00
2-2.00
3-3.00

user first selects item '2' in the repeating table then the price found is
2.00
user next selects item '1' in the repeating table then the price found is 1.00
user next selects item '3' in the repeating table then the price found is 1.00

 

[S.Y.M. Wong-A-Ton]

Are you using current() anywhere in the rule to get to the currently selected
row in the repeating table and hence current dd list box being used?

 

[Ed]

No - can you provide me with an example of using current(). I looked in Help
and see the function listed with an explanation but I'm notsure where to
apply it. Currently the rule says set the price to the price in the
secondary data source with a filter of product no(secondary) = product no
(main). Where should I added the current() function?

 

[S.Y.M. Wong-A-Ton]

For an example using current() take a look at the solution posted here:
http://enterprise-solutions.swits.net/infopath/shrinking-dropdown-list-repeating-table.htm

While not specific to your problem, it should give you an idea of how you
can use current() in your own situation. You most likely have to replace
product no (main) with current() to get the functionality you require.

 

[Ed]

Thank you - it works great now!!!
--
Ed

For an example using current() take a look at the solution posted here:
http://enterprise-solutions.swits.net/infopath/shrinking-dropdown-list-repeating-table.htm

While not specific to your problem, it should give you an idea of how you
can use current() in your own situation. You most likely have to replace
product no (main) with current() to get the functionality you require.

 

[S.Y.M. Wong-A-Ton]

Cool!
---
S.Y.M. Wong-A-Ton

Thank you - it works great now!!!