>Hi Hilmar,
>
>can you explain why you think the trigger is updating its own table? The trigger i have is on SalesDetails.dbf and it is updating the Items table. But when it tries to update the items table, the field rule on the items table fails.
Ah, yes, you mentioned on what table the trigger was, but I overlooked that.
You don't happen to have another trigger in the updated table, which will, in turn, try to update the first table (SalesDetail)? Otherwise, I don't know what might cause the "illegal recursion".
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)