I am trying to connect past transactions to employees.

In my database the field gives me the option of selecting multiple values for example:

- John Smith (JSM)
- Jack Jones (JJO)

If I select only John Smith it will insert it into my database as "JSM". If I select John Smith and Jack Jones at the same time it will insert it as "JSM,JJO".

I have tried using this formula but it only gives me one of the names

if 'JSM' in {SaleComps.condition} then ', John Smith'
+
if 'JJO' in {SaleComps.condition} then ', Jack Jones'

but it will only show the first value "John Smith" and not "John Smith, Jack Jones".