Using multiple values from a SP list

P

PACAdmin

I am trying to get the following to work, without success.

On my form it has a repeating table with the following fields; Description,
Quantity, Price and Extended price. The "Description" field is a combo box
that pulls its data (SP_Title) from a SP list.

The SP list has three fields; SP_Title, SP_Cost and SP_Category.

What I would like to happen is when they pick an item in the "Decription"
combo box that it would also update the "Price" field with the respective
"SP_Cost" details from the SP list.

Any help would be appreciated in doing this.

Regards,

Dave
 
C

Clay Fox

You can use a set field action and a filter.

So make a rule on your dropdown where they select the item description.
Add a rule with no condition so that it happens everytime the dropdown is
modified.
Use the set field value and select the target "price" field.
Enter a formula where it uses the SP_Cost field from your secondary (SP)
source but then use the filter button in the lower left of the window.
add a filter that says SP_Title is equal to the description dropdown value.
This should give you what you need.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA - Automatic change content of a cell in table using dropdown list 5
Creating a Search using a combo box and then creating a report. 4
Insert name and adress from a list in a word document 1
Combo or list box 0
Unable to display values in 2nd list box from 1st list box selection 2
EXEC SP from Button 1
Outlook meeting location auto prompts with a suggestion list - need to disable 0
Link a text box based on drop down box with four options MS Word 365 0

Top