AnsweredAssumed Answered

Relationship problems

Question asked by PeterMontague on Oct 30, 2013
Latest reply on Nov 3, 2013 by PeterMontague


Relationship problems


     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.

     But no matter what I try I can't get the relationship to work. I've checked everything many times and I can't figure out why it won't look up the information for me. Any tips?sad