InfoPath Dev

Hi Patrick Thanks very much for your response. I am not sure about having two dropdowns as you mention in option (1), if I have just one drop down and it listed say Team A Team B Team C Team D If I selected any one of these teams is it possible for the repeating table to automactically then display say e.g. Fred ...

Hi I know there are various tutorials about that show you how to auto populate a repeating table or just a field with data from a list or database when a choice is made from a drop down menu. However I have a list with staff names which has a look up column to another list called teams. So in the staff list you have staff names and the team ...