Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
210
display a value from another table (I need VLOOKUP Excel !!)
posted

hi,

i have a wingrid who displays the orders of a customer (IDCustomer, DateOrder, Amount)

i wan't to display on this wingrid some informatiions about each customer (name, address)

Of course, i can use a view in my database, but i must modify the DateOrder or the Amount and it's impossible with a view.

Can i use a formula in a textbox to retrieve this information ? (unfortunately, the Excel Function VLOOKUP does not exist !!!) 

Thanks for your answers !!

Laurent 

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    I'm sure there is a way to build a data source with the information you want that is still editable.

    But if you don't want to do that, then I recommend using unbound columns. You could use the InitializeLayout event of the grid to add columns to the band.

    Then you use the InitializeRow event to populate the values of the unbound cells with whatever information you want.  


Children