AnsweredAssumed Answered

Self Join Relationship Question

Question asked by Terri on Mar 19, 2013
Latest reply on Mar 19, 2013 by Terri

Title

Self Join Relationship Question

Post

     Hi,

     I have records that have a product code, a style number, a color, a season and a comment field. There can be many style numbers under one product code and they can have the same color assortment. For example:
      
     Product Code 123456
     Style ABCDEF
     Color White
     Season SS 2013
      
     Product Code 123456
     Style XYZ123
     Color White
     Season SS 2013
      
     When someone is reviewing style ABCDEF they may make a comment - for example - liquidate. I need to make sure that comment is also applied ot the Style XYZ123 record. I think this could be done by a self join relationship.
      
     I've created another field called PC_Color. I've created a self join relationship with the following:
      
     Data::PC_Color = Data2::PC_Color
     and
     Data::Season = Data2::Season
      
     I've also checked the Allow Creation of Records on the Data2 table. However, when I enter a comment on the Data table for PC_Color 123456_White, that comment does not transfer to the Data2 table.
      
     What am I missing?

Outcomes