Trigger SQL Server insert / update valid table field if it is in another table


my question is this: I have 3 tables

Tabla_ArticulosLote Product Warehouse Lot Physical

Tabla_MaestroArticulo Product

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

asked by Analu 25.09.2018 в 00:06

0 answers