1 Reply Latest reply on Mar 22, 2013 12:50 PM by philmodjunk

    Looking data from related table



      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.

        • 1. Re: Looking data from related table

               Not only is it possible, there are two basic approaches. One method copies data from a record in the lookup table to matching fields in the table from where you are doing the lookup. The other method simply uses a relationship to display data in fields from the related table.

               Both methods have their uses. This thread describes both approaches and why you might use one method or the other: Auto Fill