Forms Designer Forum

Good Morning,

I have a display form for a contact with a related items viewer to show all related addresses.
In the Contact Item there is a multiple Select Lookup Column for Related Addresses and I have selected an address in there (see Capture 3) However despite setting this up in the Data Source Editor as the Form Field (see Capture 1), the related items viewer on the display form displays no items (see Capture 2). What am I doing wrong?

Thanks

Hello, Tony!
First of all, this filtering is not dynamic and is only applied when you open the form, so if you change fields later, it will not change the Related Items control. The fields also must match if you want them to filter correctly like this. Since you are using Multiple Lookup, it will likely not work. If I understand it right, you want Related Items to show items that contain at least one from selected items in the Lookup, right?

You can experiment with dynamic filtering, it uses hashes to filter content of Related Items. Not very easy to use, but gives much more control over what is displayed in Related Items at any given point. With the right JavaScript, you can implement filtering by each selected item in the Multiple Lookup field.

But you can always just change to Single Lookup and it should work just fine, as long as you don't need filtering to be dynamic, otherwise use the article I've linked. It's basic functionality is not too hard to implement, but some advanced situations can be quite challenging.