Aug 25 2021 03:06 AM
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.
Aug 25 2021 11:27 PM
SolutionAug 26 2021 12:29 AM
Aug 26 2021 12:41 AM
Aug 25 2021 11:27 PM
Solution