I have a list where users can add a known issue logged against a IT Device from another list, Each IT Device entered generates it's own unique number in a column called DeviceID. So for example you could have 'Laptop A' selected and the issues of 1) poor display and 2) fragile screen logged against it, in DeviceID it has the number '6'.
What I need to happen is that as soon as the number of issues logged against an IT Device reaches 5 or more that it generates an email.
The problem I've got is that the IT Device field is free text and could be anything (Palm Top B, Desktop C).
I think what I need to do is to find a way in the Workflow so that when the DeviceID = 'whatever the number is' add a 1 to a variable, when variable = 5 send email.
Any ideas?