Diane,
As you say you just need to do all of this in the OnExit DBGrid Column EEP. Using you example, (which you are not using ?), and relating that to a form I have, I have a computed column for the total cost; the user enters the quantity and then the unit price can be entered manually, or extracted from another table, via various methods. I use the RBTI_FORM_COLNAME to check the column just exited and then do whatever is required based on that. It all is pretty straightforward - if you would like me to send you more details let me know. (I find the DBGrid an extremely useful object - it has had numerous features added to it which have made it even better in recent years.) Regards, John Docherty From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 3 October 2008 8:55 a.m. To: RBASE-L Mailing List Subject: [RBASE-L] - Changing Value of DBGrid Column Using Property Hi, all, I have a main table (say, Customers) and a linked subtable (say, Orders) on a form. The subtable is displayed in a DBGrid. When the user enters a value in the column Quantity of the DBGrid, I want to be able to calculate the TotalPrice column in the DBGrid through code in an OnExit DB Grid Column EEP. For example, when I exit the Quantity column, if the Quantity is less than 100, then the price per item is $5.00; if the Quantity is >= 100 and < 500, the price per item is $4.50; if the Quantity >= 500, then the price per item is $4.00. I then compute the TotalPrice and want to pop that value in the column TotalPrice. (This is not what I am really doing; I have a different application where based on the contents of one column, I do a lookup into a table using that column and want to copy the resulting value into another column of the DB Grid.) Any ideas? I am a newbie to R:BASE Turbo V-8; the last version I worked with was 6.5++. Thank you in advance. Thanks, Diane DeMers _____ Looking for simple solutions to your real-life financial challenges? Check <http://pr.atwola.com/promoclk/100000075x1209382257x1200540686/aol?redir=htt p://www.walletpop.com/?NCID=emlcntuswall00000001> out WalletPop for the latest news and information, tips and calculators.
