It's been a while since I have had to develop a database so could someone advise how I would do the following:
I have an address database that has several records and one field is name, another field is address, phone number, etc.
I have a different database that I need to pull the name, address etc. into. We have set up on field in the second database to look up the names from our address database but how do we have the address, etc. automatically update based on the name?