Update Lookup in Different List

[thlavka]

Hi,

I have 2 lists:
-Accounts
-Representatives

When a new account is created in the Accounts list, I would like to add the account to the list of Associated Account(s) (Internal name "Associations") in the Representatives list.

Representatives list



Accounts list



Representatives list


Can this be done?

Thanks,
Tammy

[Dmitry Kozlov]

Hi Tammy,
I'd recommend you to leave just one link between entities - a single lookup column in the Accounts list. If you want to display all companies associated with a certain Rep, add a Related Items control to the Representatives form and filter it by the current item:
https://spform.com/documentation/relate ... gular-mode

[thlavka]

Thank you Dmitry. I figured out a way to do it with SharePoint Designer. I'm still learning Forms Designer but I will look into your suggestion as well.