AnsweredAssumed Answered

Relationship Help

Question asked by johnw54 on Jan 3, 2013
Latest reply on Jan 3, 2013 by philmodjunk

Title

Relationship Help

Post

     A couple of my value lists dont seem to be working properly and I'm wondering if you could look at my relationships because i think it's where the problem lies.  Each customer can have 1 default "ShipTo" location.  If the customer wants to ship to a different location I would add an additional shipto record from the button on the Customer Layout.... then when the order is created I am showing the default shipto location but would then through the drop down list select the alternate shipto and save the id to the Order table.  I believe the join between the Shipto Table and Customer table is not correct.

Relationships1.jpg

Outcomes