Why Data Macros are this much tougher?

[prabha_friend]

Please Have a look into the "AfterInsert" on the table attached in the database...

 

[June7]

Since you did not include tables used by lookup fields, data entry is not possible.

What is the issue?

I don't use macros at all. Why do you want to?