make unit price of the product to be fixed

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()

Quote:

---

Originally Posted by barrymavin

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.

Quote:

---

Originally Posted by barrymavin

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.

---

Thank you very much Barry.