Show values from other list in Form Designer

[ching29]

Hi,

I have another query, I would like to ask if its possible to show values from another list in the Forms Designer, like 'JOIN' in SQL? I would like to show some details(columns) from 'List 1' to 'List 2' using a 'primary key' that is found both in 'List 1' and 'List 2'.

If it's possible, I wouldn't like to create another column for 'List 2' just to 'Lookup' from 'List 1' because it would be tedious to update both lists when there would be a change on their values and I think it's 'Data Redundancy'.

Btw, I am using Forms Designer Client 3.1.5.

Thank you.


Regards,
Ching

[Nikita Kurguzov]

Dear Ching,
Do you mean just on the form or in the list view with other columns? If you mean just the form, it should be possible to retrieve values from the other list with JS, following this article by Microsoft. It's fairly straighforward - send the request once the form opens, retrieve the correct value with CAML query and display it somewhere on the form - either append to an existing element, or use HTML control, or insert into a field, etc.