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]