I want to manage MSDS in SP document library Requirements:
- IDH (Unique Number for each material) - Total MSDS count will be 200*3+ Picture (200No.)
- Supplier 1
- Supplier 2
- Supplier 3
- Attach Valid MSDS 3 suppliers (Validity of MSDS is 3 years from print/ Origin date) - Trigger required when document id out of date.
- Photo of the product (Master sample photo) - (Need to be seen live, not as file name)
- Search Index, with name, IDH or Finished good name (to provide list of RM goes to that FG)- Can be made and updated in separate list
Is this database can be made in SP?