AnsweredAssumed Answered

Populating Fields

Question asked by johnRees on Jan 18, 2010
Latest reply on Jan 19, 2010 by ninja


Populating Fields


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.


Kind regards