I have a number of fields that could either be lookup or choice fields and I don't know which to use. I heard using Lookup was "more sophisticated" but I don't see how it is very useful when I have to have more fields come back from the list than just Title and ID. I have to use complex filters that mean a straight Lookup doesn't work well. Does anyone have more advice for me to follow here?
InfoPath 2010 used in SharePoint 2010 list.