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