InfoPath Dev

Is this possible?

I created a secondary data source. It has a "name", "sex" & "grade" as columns.

Data: John, Male, 12
Jane, Female, 9


John column will be a dropdown - if I select 'john'. Then I would like to populate 'male' & '12' data automatically in text box control.

Or is it easier to do this instead.. if field = 'john' then 'male' and '12'?

I found it in how-to-do.
Thanks, Matt.. Again..

Automatically Populate Fields from a Drop-Down Selection
By Matt Faus, Tuesday, 18 April 2006, 10:45 AM