I think there are two questions:
1) Linked tables
Not sure you need to to do that with vars.
How 'bout a form with 2 DBGrids, top grid is invoice header, bottom is
invoice details.
Link them by invoice number...or whatever they have in common; link on
one column only.
2) Copy/paste from one grid to another
If you need to copy/paste a value from one grid to another, use an EEP
with SET CLIPBOARD .vWhatever
vWhatever is defined in the form expressions.
Then you can Ctrl-V that value wherever needed.
Doug
On 2/3/2022 12:26 PM, Dick Fey wrote:
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
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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/cf9e089b-7cec-4a16-ff70-75fd7055d921%40wi.rr.com.