here are my mappers in case that helps, maybe I don't understand the cascading properly?
# relations for the bookings mapper( Booking, booking_table, properties={ 'client': relation( Client ), 'institution': relation( Institution, ), 'category': relation( Category ), 'staff_associations': relation(BookingStaffAssoc, lazy=False, cascade='all, delete-orphan', order_by=booking_staff_table.c.ordering ) }) # Association mapper, this is the important part! mapper( BookingStaffAssoc, booking_staff_table, primary_key=[ booking_staff_table.c.booking_id, booking_staff_table.c.staff_id], properties={ 'booking' : relation(Booking, lazy=False, cascade='all, delete-orphan' ), 'staff': relation(Staff, lazy=False, cascade='all, delete-orphan') }) Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---