Hi, John.
>I need to auto-generate some records to one of my table once new item was added to item table. Should I place the code to generate those relavant records in store procedure or business object?
It depends. If this is really something related with your database structure, you better use a trigger. If this is something related with a business rule, it should be done by a biz object.
If you are not sure, just tell me what's the case in particular and we can try to apply some logic that you can replicate in other cases.
See you,