I am creating a database that will be used as a company contact list. I am going to be using the following tables and fields:
2. Last Name
3. First Name
4. Phone Number
2. Phone Number
I would like to use field7(Branch) as a lookup into Table: Branch and would like field4(Phone Number) to auto fill with field2(Phone Number) from Table: Branch.
Thanks in advance for any help.