5 Replies Latest reply on Nov 3, 2013 10:37 AM by PeterMontague

    Relationship problems

    PeterMontague

      Title

      Relationship problems

      Post

           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