I have a database with columns headed date, name, job title, organisation
etc. I repeat some of the people as I go down my list in different dates.
What I want to know is how can I enter these same people further down in the
list and have their related information in the adjacent fields (such as the
job title, oraganisation etc.) filled in automatically without me having to
manually copy and paste the data. Could you help me please?