Re: [RBASE-L] - WHERE

2022-02-03 Thread Doug Hamilton
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 gr

Re: [RBASE-L] - WHERE

2022-02-03 Thread 'Karen Tellef' via RBASE-L
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 To:

[RBASE-L] - WHERE

2022-02-03 Thread Dick Fey
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 th