Thank you! Your explanation helped me understand what they did. They didn't use triggers though. I think they're doing it in the front end application. There...

Well, on either one of the tables, if you right-click and look at View Dependencies, you will see the other table in both "objects that depend on.." and in "Objects...