Can't you use a good old-fashioned form variable? Just define a form variableequal to the PK or some other identifier of the row the user has just clicked on?You can use a "getproperty" in the grid eep, but form variables are very easy Karen -----Original Message----- From: Dick Fey <d...@carpetbroker.com> To: RBase Maillist <RBASE-L@GoogleGroups.com> Sent: Thu, Feb 3, 2022 12:26 pm Subject: [RBASE-L] - WHERE
Somewhere in my foggy mind, I remember a way to click on a line in a dbgrid and have it update that line with a variable using WHERE current of cursor. What I want to do is populate a field on one line with a variable for another table. IE: Top table is a vendor invoice. Clicking a line there populates order lines for that order into a second DBGrid Need to update specific lines in the second table with a number from the first table by clicking the appropriate line. I think the Covid has fogged by brain. Dick Fey Carpet Broker Inc P-913-894-9211 F-913-894-0138 -- 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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/57e0e065-7f9a-2708-0020-8a3783f7c7c4%40carpetbroker.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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1035445468.4468992.1643913723928%40mail.yahoo.com.