how primary key contain table's data automatically entered in foreign key contain table's data
I am working on filemaker pro 8.5. i am working on to two tables and these tables have primary key foreign key relationship. Like first table contain Emp_ID ,Emp_Name etc and second table contain data related to employee performance. In second table contain field Emp_ID as a foreign, Emp_Name and etc. So i want when i entered data in foreign key than Emp_Name field of second table will automatically filled by corrosponding data.