After some playing(couple of hours) with the enhanced dbgrid I found a workaround.
I added a column that I am not using. Then I went into the column properties-enhanced properties. I changed the field-type to lookup expression and typed in the expression. I also made that column read only. That works. Each row has a description next to the part number. The only thing is the user will have to save to see the current row description when it is changed. Thanks for all your suggestions. Dan Goldberg -----Original Message----- From: Mike Byerley Sent: Friday, February 10, 2012 11:50 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Using a lookup variable in a db grid Approach 1 is what usually use and can be instrumented a couple ways. Static text changed via property command based on row level eep or variable control (var edit or var static text) changed via the method you describe. ----- Original Message ----- From: "Javier Valencia" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, February 10, 2012 2:29 PM Subject: [RBASE-L] - RE: Using a lookup variable in a db grid : Dan, : : : : I have two approaches to get around the issue. : : : : Approach 1: : : In the variable section create a lookup variable VDesc = Desc IN DescFile : WHERE PartNo = PartNo : : Now place the variable vdesc somewhere in the form; just above the grid is a : good place. : : Now, whenever you enter a new grid row, the variable above the grid will : display the correct description : : : : Approach 2, : : Add the DescFile to the form : : Add a non-editable grid to the form with data from the DescFile : : Select the columns from the DescFile you want to display : : Make the grid one row tall and place it just above the original grid : : Now, the thin top grid will display the description (and other columns : selected) for the part on the selected grid row : : : : Makes sense? : : : : Let me know if you need me to e-mail you screen shots and details : : : : Javier, : : : : Javier Valencia, PE : : O: 913-829-0888 : : H: 913-397-9605 : : C: 913-915-3137 : : : : From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg : Sent: Friday, February 10, 2012 9:19 AM : To: RBASE-L Mailing List : Subject: [RBASE-L] - Using a lookup variable in a db grid : : : : I would like to use a dbgrid for data entry. : : : : I have a part number field in the grid and I would like to have the : description of the part number in the field next to it. : : : : The description is in another table. So it would be a variable lookup. : : : : I have figured out how to do a hint expression but the user would like to : see the description in the grid without having to put the mouse over each : item. : : : : I was wondering if anybody has ran into this and has any suggestions. : : : : TIA : : : : Dan Goldberg : : --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
