https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3721.aspxFri, 22 Dec 2006 15:14:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3721schung0https://www.infopathdev.com:443/forums/thread/3721.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3721I found it in how-to-do.<br />Thanks, Matt.. Again..<br /><br />Automatically Populate Fields from a Drop-Down Selection<br />By Matt Faus, Tuesday, 18 April 2006, 10:45 AM<br />https://www.infopathdev.com:443/forums/thread/1755.aspxFri, 22 Dec 2006 14:13:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1755schung0https://www.infopathdev.com:443/forums/thread/1755.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1755Is this possible? <br /><br />I created a secondary data source. It has a "name", "sex" & "grade" as columns.<br /><br />Data: John, Male, 12<br /> Jane, Female, 9<br /><br /><br />John column will be a dropdown - if I select 'john'. Then I would like to populate 'male' & '12' data automatically in text box control.<br /><br />Or is it easier to do this instead.. if field = 'john' then 'male' and '12'?<br />