Substract from 2 different columns and tables

PHPMaker General Discussion (PHPMaker)
1

Guys I need help, tried searching but still couldn’t find the answer. I have 2 tables with several columns. This is an inventory system and I want to know the balance in a specific column.

Table 1
ID (int)
product (char)
Company (char)
Stock_in (int)

Table 2
ID (int)
product (Char)
Department (char)
Quantity (int)
Balance (int)

Ok my question is, I want the Balance column in Table 2 to auto count table1.stock_in - table2.quantity. How can I do that and where do i have to put the codings? Kinda noob here…thank you in advance guys !

2

You can use the Row_Rendered server event for the calculation. Perform a ExecuteScalar to get the stock from table 1 based on product, then calculate the difference.