Does anyone have a SQL Query (i guess that is what it is called)
I want to make a trigger that will run anytime the cost of a parent item is updated. If i cant run a trigger I would still like to be able to run the SQL query anytime I feel I need to make sure my child cost should be changed. So this is how i think it should happen. cost of parent / the MPQ of the child should = the cost of the child in the suppliers tab and in the general cost.
Im not sure if anyone already has a SQL for this or not. But as everyone knows that is using RMS the child cost is not addressed at all. So I think this query would be helpfull to lots of people.