Hello...
I make grid section about sales the product. How do I make unit price of the product to be fixed from table “Products”.
Thanks
Venus
Printable View
Hello...
I make grid section about sales the product. How do I make unit price of the product to be fixed from table “Products”.
Thanks
Venus
Hi Venus
use sqllookup() in the column data source
https://www.lianja.com/doc/index.php/SQLLOOKUP()
Hello Barry,
I mean that I make grid section about sales or purchase the product. How do I fill columns grid with PRODUCT NAME and PRICE automatically when I choose PRODUCT ID. We know that PRODUCT NAME, PRICE AND PRODUCT ID are from PRODUCT TABLE. You see my attachment.
Specify a calculated column expression that uses the sqllookup() function referencing the product id and then return the product price then multiply it by the quantity.
You can programatically update columns in the grid "rowcolchange" delegate.