CLOSED : function Max() problem

[Chrissy]

I think instead of using
{Table1.AUDIT_ID}= Max({Table2.AUDIT_ID})

you need to use

{Table1.AUDIT_ID}= (SELECT Max({Table2.AUDIT_ID}) from ... where...) and {Table1.ERROR_MESSAGE} like "*Validation*"