I've tried searching for this as I'm sure others have had the question but can't find a way to word it to find a result.
I have two lists setup - one with a list of people and their data (IDs, First, Middle, Last, etc) and another list for incidents. I wanted to use a lookup at first so I could point to the list of people and pull in multiple fields - Sharepoint does this great.... however it doesn't allow you to sort the list which is why I went the InfoPath route.
I currently have a dropdown list setup to get choices from an external data source (the People list) and it's does a fine job... I just can't figure out a way to also pull in additional fields from the people list. For example, I can choose John Smith on the list, but how can I automatically pull his additional fields into the Incident list?