can you convert one object record to multiple records of another objects? e.g : Lets say we have one BASKET object with a multi-value field FRUITS (one-to-many relationship with FRUIT_TYPES object).... We have one record BASKET A with apple, orange, lemon as its FRUITS and we have to convert this to object FRUITS_SOLD... So basically we want one record for orange, lemon and apple as FRUITS_SOLD object type..
Object Script triggers offer a great deal of flexibility. You can do all listed above and much more. Please check out Chapters 6 and 10.