Line by Line Relationship

[cenzer]

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

[glenwf]

That sounds like a simple relationship. If so I've solved those with using fields called "DB Popup". You might read about those.

They are easy to understand and set up if they will do the job for you. I usually get too confused trying to make real relationships work so I use the DB Popups.

[cenzer]

Thank you

I will give this a try