Hey, I got it working. I was copying and pasting the value formula into the value field and it didn't like it. I had to go through the steps of clicking on the icon, selecting my job_name field from my secondary data connection, clicking Filter Data and adding Job_no = ddl_jobno.
Thanks for your help guys!