Hi Greg,

The key is creating two data variables.  One to retrieve the list of items and the second to bring back the details of the item that your user selected in the form.  I have a similar example where someone picks a department and then we display details about that department.

Step 1:

I created a data variable called Department List and got it to retrieve all departments and then I populate my drop down list with that collection.  I’m displaying the department name and saving the department name.  I’m going to use that department name later so make sure it is unique e.g. you could display the item description but you could save the primary key instead.

Step 2:

Create a second data variable, also connected the same data source but this time you’re going to create a condition that retrieves only the item that equals the item picked in your drop down list.  See my department example below.

Step 3:

Now I can create a label and display any of the attributes that are associated to that specific department.  In my example, I’m going to show cost centre.

Here it is in run time

I hope that helps.

Thanks a lot Chris, I’ll try this out over the next few days and I’ll be sure to mark this answer as correct when I get it working.

Also thanks for all the pictures and detailed advice, I’m excited to try this out.

Hi Chris, this worked for me, thanks again for your help!

Awesome Greg!