When you say "I cant get it to work like it should with your example." do you mean the database that I posted doesn't add record or update a record when it has been changed?
So if lngPosID has to be zero how can you put it in the tblEmployeeLevel table, because it cannot accept a zero as it does not exist in the Level table?
I obviously do not understand that part of your code.