I would say no, unless you have business rules setup to do that.  Hard to say without understanding how you tables are setup.

 

Set this up in a DEV Instance and test it out is my recommendation.