Kayza:
Look at my print-screen in the original email. You click on the column in your
Grid, and click on Column Properties. Go to Enhanced Properties tab, select
"lookup expression" as the field type and then type in the expression as I
have it below. You put the name of the Grid's column in < > as shown in
the print-screen
Karen
-----Original Message-----
From: Kayza Kleinman <[email protected]>
To: [email protected] <[email protected]>
Sent: Sun, Dec 8, 2019 8:49 pm
Subject: RE: [RBASE-L] - DBGrid vs Scrolling Region
#yiv6902992970 -- filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv6902992970
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv6902992970
p.yiv6902992970MsoNormal, #yiv6902992970 li.yiv6902992970MsoNormal,
#yiv6902992970 div.yiv6902992970MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv6902992970
a:link, #yiv6902992970 span.yiv6902992970MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6902992970 a:visited, #yiv6902992970
span.yiv6902992970MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6902992970
p.yiv6902992970msonormal0, #yiv6902992970 li.yiv6902992970msonormal0,
#yiv6902992970 div.yiv6902992970msonormal0
{margin-right:0in;margin-left:0in;font-size:11.0pt;font-family:sans-serif;}#yiv6902992970
span.yiv6902992970EmailStyle19
{font-family:sans-serif;color:windowtext;}#yiv6902992970
.yiv6902992970MsoChpDefault {font-family:sans-serif;}#yiv6902992970 filtered
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv6902992970 div.yiv6902992970WordSection1
{}#yiv6902992970 How do you get the lookups working in edit mode? I seem to be
missing something there. From: 'Karen Tellef' via RBASE-L
<[email protected]>
Sent: Wednesday, November 13, 2019 6:36 PM
To: [email protected]
Subject: [RBASE-L] - DBGrid vs Scrolling Region I'd love to replace all
scrolling regions with DBGrids, but this situation is one where I have trouble
figuring out how to use DBGrids to achieve the same end as an easy scrolling
region would be. I need to bring up a form with: ENTER USING <formname>
User will be entering multiple rows at once. When the user types in an
Inventory#, I need 5 other "variable" type of fields to display immediately to
show details of that inventory# they typed in (like description, color, etc).
When using a DBGrid in edit mode, I would set up a Enhanced Properties /
Lookup Expression as below to display the values (and make that column
read-only so the user doesn't change it) However, when doing "enter
using" it appears nothing will work until I leave the row and thereby save it
even tho I am using the required < >. I tried setting a vPCGS# form variable
and replacing the <pcgs#> in the print-screen with a variable, but also does
not evaluate until row is saved. Is there anything I can do to use a DBGrid
rather than a scrolling region? Do I need to play around with the new
"UPDATEDFIELDNAME" property / TEXTVALUE commands (again, I'm assuming these
won't work with an "enter using")? A scrolling region would work fine, but
darn it I want a DBGrid! Suggestions?? Thanks, gurus! Karen --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1008021244.549224.1573688151067%40mail.yahoo.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BN8PR15MB25968CE5894AA5BEB1BC7414C5580%40BN8PR15MB2596.namprd15.prod.outlook.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/1569992503.5646856.1575901708705%40mail.yahoo.com.
