Need some help connecting multiple sharepoint lists

[thebigmic]

Hi I'm trying to create a SharePoint list (or form) that can take the contents of another SharePoint list eg. (a column containing a list of product names) and use those names as options, so if an admin updates the list of products, the choices in the other list gets updated as well. Basically I'm trying to separate the admin side from the user side more or less. Is there any way of doing this? I'm also thinking of making a form for the user list, but I'm a complete noob when it comes to this, any help will be greatly appreciated, thanks!

[zmansuri · Accepted solution]

List A will be Admin Side which will have a Text type column "Products" and there will be 3 records

Product A

Product B

Product C

List B will have LookUp type column named "Product_LookUp" which will reference to "Product" Column of List A.

When you will create a form using List B. It will only show those options that are in List A

[thebigmic · Accepted solution]

Thanks for the reply, for future people, follow this article https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/

The lookup option is burred under a couple of menus that seam completely unrelated for beginners. Thanks Microsoft!