I want to relate the same field in two databases line by line
Data.pdb Display.pdb
Each has a DATE field Each has an ITEM field
Using RELATIONSHIP:
I enter that amount into DATA:ITEM and ALL the lines of ITEMs in DISPLAY become the latest ITEM
I want the ITEM on each DATE in the DIPLAY.pdb to be the same according to Date as the DISPLAY.pdb
Thank you
What's a PDB file? Assuming that you meant DBF, and that Data to Display is a One-to-Many relation and that the master record in data has a unique Item per record and that Display carries that Item on all relevant records..
USE Data IN 0 ORDER Date USE Display IN 0 ORDER item
SELECT Display BROWS LAST NOWAIT
SELECT Data SET RELATION TO Item INTO Display BROWS LAST NOWAIT
Now just position both windows side by side, scroll through Data and see Display refresh accordingly.
I think that's a Paradox database file, no?
It's been so long, and I had a vague memory of how to do this with a browse and set relation to. Thanks for the reminder, wOOdy.
E
On Fri, Sep 24, 2021 at 9:18 AM Jürgen Wondzinski juergen@wondzinski.de wrote:
What's a PDB file? Assuming that you meant DBF, and that Data to Display is a One-to-Many relation and that the master record in data has a unique Item per record and that Display carries that Item on all relevant records..
USE Data IN 0 ORDER Date USE Display IN 0 ORDER item
SELECT Display BROWS LAST NOWAIT
SELECT Data SET RELATION TO Item INTO Display BROWS LAST NOWAIT
Now just position both windows side by side, scroll through Data and see Display refresh accordingly.
[excessive quoting removed by server]
Thank you The idea of a popup probably will solve this problem in HanDBase which uses PDB files
On Fri, Sep 24, 2021 at 5:18 PM Jürgen Wondzinski juergen@wondzinski.de wrote:
What's a PDB file? Assuming that you meant DBF, and that Data to Display is a One-to-Many relation and that the master record in data has a unique Item per record and that Display carries that Item on all relevant records..
USE Data IN 0 ORDER Date USE Display IN 0 ORDER item
SELECT Display BROWS LAST NOWAIT
SELECT Data SET RELATION TO Item INTO Display BROWS LAST NOWAIT
Now just position both windows side by side, scroll through Data and see Display refresh accordingly.
[excessive quoting removed by server]
-
Charles Hart Enzer, M.D. -
Eric Selje -
Jürgen Wondzinski