Sorry, I'm not going to "...write the trigger out in full..." for you. I'll try to help
you write it, though. I don't mean to be difficult here, but I ascribe to that theory about "...teaching a man to fish...".
If you are getting an error about 'tbl_session_booking' being an unrecognized column, then your code is placing that table name in a context where the compiler expects a column name. So, for example, in my previous suggestion:
Code:
UPDATE tbl_session_booking
...
ON tbl_session_booking.<primarykeycolumn>=inserted.<primarykeycolumn
since you've said your primary key is 'booking_id', the code should read something like:
Code:
UPDATE tbl_session_booking
...
ON tbl_session_booking.booking_id=inserted.booking_id
did you perhaps forget the period between the table name and the column name? If you post the code you are having trouble with maybe together we can figure out what you are doing wrong.
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
