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
