Dear members of the forum,
I am trying to solve a quite complicated idea (for me) and hope to find some inputs for this here:
The idea is to make a tool, where you can choose between different GHS-hazard-pictograms for a product (max 5 per product) and then show in which rooms (they have different safety levels) the product can be handled.
All of the GHS-hazard-pictograms, rooms and B-Terms (I will explain later) are stored in a database.
Sometimes these products can be handled in a room but need additional safety precautions. Those are numbers from 1-11, labeled next to the room in the database. This information should be shown next to the rooms where it can be handled.
Last part: Almost all of the GHS-hazard-pictograms have additional requirements (B-Terms), which are stored in a separate database. Depending on the chosen GHS-hazard-pictograms it should be shown which additional requirements are necessary. The B-Terms sometimes change if the product is solid or liquid, so this has to be taken into account.
To explain it better, I made a sample workbook.
Because its just an idea, please feel free for new arrangements in the database etc.
Thank you in advance for your help and best regards,
David
Bookmarks