Oh I do not prefer the triggers. Let me find a link to a much better way. You do not have to use triggers for this. You can set constraints let me show you.
This is a great tutorial its rather advanced and you may not need all of it. But look at this and study it it will teach you some advanced functions of Samba.