 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / March 2006Lookup values in a secondary data source from a repeating table?
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  SignatureEd 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? --- S.Y.M. Wong-A-Ton > 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 [quoted text clipped - 13 lines] > 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 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? SignatureEd > 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? [quoted text clipped - 18 lines] > > 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 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 > 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 [quoted text clipped - 24 lines] > > > 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 Thank you - it works great now!!! SignatureEd > 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 [quoted text clipped - 33 lines] > > > > 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 Cool! --- S.Y.M. Wong-A-Ton > Thank you - it works great now!!! > [quoted text clipped - 35 lines] > > > > > 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.