I'm having a problem populating two txt fields in a print view. Here is what is happening. I have 2 drop downs. One is "Current job title" and the other is "New job title". I have a data connection to a SP list that has 1 column of all the job titles. The drop downs do work I guess, but when I set the 2 txt fields, CurrentTitle and NewTitle, they both populate with the same job title (seems to populate with whichever title comes first in abc order). I've tried using a 2nd data connection to the same list and it does that same thing. I've tried making a 2nd column in the look-up list with the same job titles and querying that, but it still doesn't work. What am I doing wrong? Please help!
Thanks!