Search results

Thankyou everyone for your replies, I had a bit of a think about how I could do this and although its not entirely accurate, its a dirty way to suggest the Department(s) The Table 1 provides the keywords and an associated Department. Where there are duplicate keywords for different departments...

Hi All, I have three tables one with a field called Problem.[issue] which is a long text field (memo), in another other table is an unrelated field with a short text field, Department.[Responsible]. The last table contains a field with keywords and a field with the corresponding responsible...