This content has been marked as final. Show 2 replies
You don't need a Emp_Name field in the Performance table. Simply place the Emp_Name field from the Employess table on a layout of Performance.
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.