AnsweredAssumed Answered

Relationship problems

Question asked by PeterMontague on Oct 30, 2013
Latest reply on Nov 3, 2013 by 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

Outcomes