function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Trigger to update list of records



I struggle with a trigger that needs to create new records in an object called POSITION. The records should be created when a record in another object called TRANSACTION are updated or inserted. Then in POSITION I want the field INSTRUMENT to automatically create a record for all instruments that are in the object TRANSACTION (but no duplicates).


Can anyone help me with as exemplary code for a trigger? Mine is definitely wrong ;-(


trigger UpdatePosition on TRANSACTION__c (after insert, before update, after update) {

Map<ID, TRANSACTION__c> updateMap = new Map<ID, TRANSACTION__C>();

List<POSITION__c> itemList;

set<Id> AllItems = new set<id>();

for(POSITION__c i :itemList){


List<TRANSACTION__C> AllTransactions = [SELECT id, INSTRUMENT__c

                   FROM TRANSACTION__C where id in :AllItems];


what u want??

Just tell me clearly.After that only i solve ur problem.



Whenever a new record is created in my object "transaction" for a specific product, i want the system to automatically  update my products in stock in my object "positions". If the transaction refers to a product that has never been in stock before, I want the system to create a new record in my object "positions" with an initial stock equal to the transaction amount.


In short, a change in one object record shall trigger create new record/update existing record in a different object.


I hope this makes it clearer. Thanks for your help.