make unit price of the product to be fixed

[venus]

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

[barrymavin]

Hi Venus

use sqllookup() in the column data source

https://www.lianja.com/doc/index.php/SQLLOOKUP()

[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.

[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.

[venus]

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.