Hi. I'm having terrible difficulty setting up a relationship between my sales table and my contacts table. I've been trying to set up a relationship using the name field as the key field in both the sales table and the contacts table. I am using a script when I enter a new name into a sale to create a new record in the contacts table. I want to use the relationship to look up the newly created contactID in the contact table and put this in the sales_fk_contactID field. Then I will use the relationship to populate the sales::address field which will also look up this information from the contacts table.