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!