my question is this: I have 3 tables
Tabla_ArticulosLote Product Warehouse Lot Physical
Table_BagsArticle Product Warehouse Quantity
What I'm looking for is that when making an insert / update in Table_ArticulosLote validate that said product is in the Master_Article Table if it is to update the quantity field in Table_ArticlesLote and insert a record in Table_ArticleAliances.
I hope it has been understood. Thanks