Hi all, Can anybody tell me why this rule doesn't work?
MESSAGE : Limit of [ 10 ] entries reached! TABLE : Top10_Performances Row is added or changed if condition SUCCEEDS WHERE : Top10_Performances.Inst_Type IN ( SELECT Inst_Type FROM Top10_Performances GROUP BY Inst_Type HAVING COUNT(Inst_Type) <= 10 ) I'm trying to limit the number of rows for any individual value in Inst_Type to a maximum of 10 (10 guitars, 10 drums, etc.). At the moment whichever I way I try this (succeeds or fails) I cannot change anything even though there are only 5 rows in the table. Thanks in advance, Regards, Alastair. ---------------------------------- A D B Burr, St. Albans, UK. ---------------------------------- [EMAIL PROTECTED] ----------------------------------
