I am using filemaker 10 and trying to populate a foreign key. I have the relationships set up between the customers and the invoices such that the kf customers in the invoice field is populated by the kp from the customers. I have ensured that the kp is set to be read as the customer name and chosen the choose second field option so this can happen. When I click into the field the drop down menu occurs and lists all the names of the customers as expected. However, when I click on the chosen customer from the menu two things occur. First the customer kp code is entered and in addition there is a message that states that the kp field 'is defined to contain unique values only. Allow this duplicate value.
Can anyone help.