Darkmatter5 Posted February 24, 2009 Share Posted February 24, 2009 I have 2 tables lvl2prod levelproduction 02 15 plots plot_idlevelprodvalue 102 215 Now I'm wanting to create a trigger for the prodvalue in plots. I want it to get the production value from lvl2prod and update that value into prodvalue when level in plots is updated. Can you have it pull data from another table to use as what to update a field to? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.