Sign Up ›
  • Blanche Callazo 47
  • NEWBIE
  • 0 Points
  • Member since 2020
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
SOLVED
9 replies

how to update field using trigger

these are my objects:
       Object                              Field
Reservation__c          Seat__c(lookup)
     Seat__c                Taken__c(checkbox)
i need to update Taken__c whenever a new record of Reservation__c is created or updated.
 
i tried this code but didn't work:
trigger updateSeatTaken on Reservation__c (before insert, before update, after insert, after update) {
    for (Reservation__c r : trigger.new) {
           Seat__c takenSeat = [select name, taken__c from Seat__c where id =: r.id];     
                   r.Seat__r.Taken__c = true;
                   update r;
    }
}

an error showseverytime i create or update a Reservation__c record:
Apex trigger updateSeatTaken caused an unexpected exception, contact your administrator: updateSeatTaken: execution of BeforeInsert caused by: System.QueryException: List has no rows for assignment to SObject: Trigger.updateSeatTaken: line 3, column 1

any help?
  • January 07, 2014
  • Like
  • 0