I need to create a SP list of certifications from an Excel spreadsheet.
I need to create a SP library to archive existing and new certification documents/images and upload existing document/image to library.
The certification documents are/can be pdf or image files - (should this library be a 'Document' or 'Image' library?).
Each Employee may appear on the certification list once or mulitple times based on the number of certifications they have.
Each Employee may have one or more certification documents in the library.
There are fifteen different certification titles available to choose from.
Each Member has a 'UniqueID'. The UniqueID is formatted as follows and appears allowing side each 'Item' (certification) on the SP list associate with the Member.
UniqueID = First Initial First Name / First Initial Last Name / Last Four of SSN
Member: Joe Schmoe
Last Four: 1234
The Member's will need to ability to update, edit, or delete items from the SP list and associated item in the SP library.
At list and library creation (and for all addition of modifications to the SP list), how do I associate each line item on the SP list to its unique and specific document/image in the library?