SOLVED

SharePoint - Item Tagging

%3CLINGO-SUB%20id%3D%22lingo-sub-2682650%22%20slang%3D%22en-US%22%3ESharePoint%20-%20Item%20Tagging%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2682650%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%2C%20hoping%20to%20get%20some%20suggestions%20on%20a%20'problem'%20I%20have%20to%20solve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%2C%20our%20company%20has%20a%20list%20of%20say%202000%20products.%20Each%20of%20those%20products%20has%20an%20external%20certification.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%201%20to%20many%20relationship%20between%20the%20certificate%20and%20the%20products.%201%20cert%20could%20cover%20100%20products%20(each%20with%20unique%20codes).%20Unfortunately%2C%20the%20certificate%20doesn't%20list%20the%20the%20unique%20part%20codes%20that%20are%20covered%20by%20the%20cert%20e.g.%20the%20cert%20will%20save%20%22this%20covers%20the%20XYZ%20range%22%20where%20the%20actual%20part%20codes%20are%20XYZ1%2C%20XYZ2%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20were%20to%20create%20a%20new%20SharePoint%20list%2C%20load%20my%20products%20in%2C%20is%20there%20a%20way%20I%20can%20link%20the%20certs%20to%20particular%20products%20in%20bulk%2C%20without%20having%20to%20go%20in%20to%20each%20individual%20line%20%26amp%3B%20attach%20the%20certificate%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20essentially%20want%20a%20way%20for%20staff%20to%20access%20copies%20of%20the%20relevant%20certificate%20for%20particular%20products.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20the%20idea%20of%20using%20a%20SPT%20list%2C%20because%20the%20certificates%20have%20a%20validity%20period%2C%20so%20I%20can%20use%20dates%20to%20trigger%20reminders%20to%20the%20person%20in%20charge%20of%20renewing%20the%20certificates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2682650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2686503%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20-%20Item%20Tagging%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2686503%22%20slang%3D%22en-US%22%3ESounds%20like%20you%20need%20to%20create%20a%20Lookup%20column%20in%20your%20products%20list.%20Configure%20the%20Lookup%20column%20to%20use%20the%20Certificates%20List%20(or%20Library)%20as%20the%20lookup%20data.%20%3CBR%20%2F%3E%3CBR%20%2F%3EOnce%20that%20is%20done%2C%20you%20can%20use%20Edit%20in%20Grid%20View%20to%20bulk%20edit%20your%20products%20list.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi everybody, hoping to get some suggestions on a 'problem' I have to solve.

 

Basically, our company has a list of say 2000 products. Each of those products has an external certification.

 

There is a 1 to many relationship between the certificate and the products. 1 cert could cover 100 products (each with unique codes). Unfortunately, the certificate doesn't list the the unique part codes that are covered by the cert e.g. the cert will save "this covers the XYZ range" where the actual part codes are XYZ1, XYZ2 etc.

 

If I were to create a new SharePoint list, load my products in, is there a way I can link the certs to particular products in bulk, without having to go in to each individual line & attach the certificate?

 

We essentially want a way for staff to access copies of the relevant certificate for particular products.

 

I like the idea of using a SPT list, because the certificates have a validity period, so I can use dates to trigger reminders to the person in charge of renewing the certificates.

3 Replies
best response confirmed by TeamProMember (Occasional Contributor)
Solution
Sounds like you need to create a Lookup column in your products list. Configure the Lookup column to use the Certificates List (or Library) as the lookup data.

Once that is done, you can use Edit in Grid View to bulk edit your products list.
Thanks Steve, makes perfect sense now you mention it. One more question, is it possible to display a column in 1 SPT list, in a 2nd SPT list? (both in the same site) i.e. the certificate list has the expiration date column. I want to show this on the product list if possible?
Yes, when you create the Lookup Column you can specify additional columns to display. Here is the full reference.
https://support.microsoft.com/en-us/office/create-list-relationships-by-using-unique-and-lookup-colu...