Looking data from related table
I need help with related tables. I have one that is my "agent" database and the other is my "customer" database. I want to be able to put the agent number in the customer file when I'm creating the customer file and have it automatically pull the agent's last name from the agent database and put it in a field in the customer record. I'm sure it's possible, I just haven't figured out how to do it.