• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 652
  • Last Modified:

InfoPath Field Values

Hi experts,

Currently I am creating a InfoPath 2010 form with data connections associated. I am attempting to populate a "Sales" member's name and commission rate from a SharePoint list. The list is setup as a Data sources within the form.

What I would like to see happen is when I select "SalesPerson", I would like it to auto-populate their commission rate in another field. To avoid additional data entry.

I have tried every combination with filters and formulas, but have still been unsuccessful.

Any help will be much appreciated!

Thanks,
TG
0
techguy57
Asked:
techguy57
  • 2
1 Solution
 
techguy57Author Commented:
The form is also being created to be used within a browser..
0
 
Clay FoxDirector of Business IntegrationCommented:
I would create a rule on the control where you select the sales person.

make the action to set a field value.
Commission field in your form should be the target.
The formula would be to select commission field from your data connection but then use the filter button in the lower left of that browse box.
then select salesperson in the data connection list equals the sales person field in your form that was just set.

Usually it is the filter that people miss.  Which is easy to do.
0
 
techguy57Author Commented:
That did it! Something so simple. Thanks a lot!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now