Suppose I created 2 tables One table name is products And second table is sales When I doing entry in sales product Then product table records also minus Such as total product (minus)- sales product In shortly I have use 2 tables in one record . Using Microsoft sql server 2014 And c# For desktop standalone application