Have you looked into using the DataAssist insert and update Server Behaviors. You can access both of them by going to the Server Behaviors panel (Window -> Server Behaviors) and click the + button and select DataAssist and you can then select insert or update server behavior.