InfoPath Dev

I am new to InfoPath but not SQL. I have built a very basic Infopath form. It uses a table from SQL Server to load a drop-down list. The table contains 2 additional fields I would like display on the form but I do not know how. I have a sample below of what I am asking (below). Any ideas? Thanks in advance. Record Retention Schedule ...

that got it. thanks.

I am new to InfoPath so if did not ask the question correctly I apologize. I have text text field that has the following text in it "i:o#.w|nsna\jdoe". I believe this field has the user name in it, domain\username. I want to take the user name of jdoe and put it in another text field. I have setup a rule that has a condition ...