>Gil:
>
>I can't believe that it's that hard: I have got this to work before.....I'll put together a dummy grid with a simple item/order_items dataenvironment and email it to you...I'll alert you to it in this thread when done.
>
>

*** Here I am replying to myself...OK....try to denormalize the description, putting it in the line and doing a REPLACE to grab it from the items file. Maybe you already have price denormalized (in both files not just oin key into items)?





>>John:
>>
>>I did set the sparse property to .T. and with it, I get a very strange effect. If I have an item on the first line of the grid and I want to select a new item for the second line, the code and price values returned for the item selected are correct but the description of ALL the lines in my description column get changed to the description of the new item selected. The sparse property when set to .t. the CurrentControl property affects all cells, and if I set it to .F.
>>it won't even hold the description on the line anymore. As far as the methods used on product selection and calculations, everything works fine; the grid display is the only area with problems.
>>
>>Thanks,
>>
>>Gil
>>
>>P.S: I exchanged e-mails with a fellow that was trying to do the same trick and he simply gave up after spending too much time on it. For now, and because the deadline for this project is arriving soon, I've decided to use a popup listbox that will solve the problem temporarily; but just for the sake of it, I want to get this done because it will have very useful applications in some other areas of the system.
>>
>>Thanks again.
>>
>>
>>
>>>OK, Gil....think I understand now.
>>>
>>>On that OE grid in Taz, the column has Sparse=.T. property set with a Combobox for entry and textbox for display. The combobox read from an items file with a control source of the items key value in order_lines. In the InteractiveChange method of the combobox, price information is REPLACED in order_lines with that of the selected item. Extended price is recalculated and also REPLACED. The grid is then refreshed.
>>>
>>>Maybe you were missing some event code or something?
>>>
>>>
>>>
>>>
>>>>Thanks John, and like I said before, I've emulated pretty much every single aspect of it and still mine won't work. But anyway, thanks for the effort and good luck.
>>>>
>>>>Gil
>>>>