Hi,

I wanted to know how to do what I'm attempting to do at the minute.

I have a list of names that have unique numbers with them and I need to show what training they have had in a visual display like below.

Unique No. Last name First name Chemical Hazard Safety
8021206 Piper Scott GREEN RED GREEN
8059732 Smith Jon GREEN GREEN GREEN

I have a select list of names and numbers that need to be checked against a list of all training that has taken place. Similar to the below.

Unique No. Last name First name Training
8021206 Piper Scott Chemical
8021206 Piper Scott Safety
8059732 Smith Jon Chemical
8059732 Smith Jon Hazard
8059732 Smith Jon Safety

Any help would be greatly appreciated as I'm exhausted trying this!