AnsweredAssumed Answered

Copy the value by relationship

Question asked by henryhu91 on Sep 19, 2013
Latest reply on Oct 17, 2013 by philmodjunk


Copy the value by relationship


     Hello FM users, 

     I've one table that I'm trying to condition and set up relationship to set variable value from one field to another.

     For example, these are the fields in my database. 

     Item     Part Number     Name      Parent Item    ParentPartNumber

1          001                 Apple       0

1.1       002                 Orange     1                    001

1.1.1    003                 Banana     1.1                 002

1.2       004                 Cherry       1                   001


     What i'm trying to do is to have ParentPartNumber auto create and if Item=Parent Item, I would like to have Parents PartNumber auto copy the Part number. I would really appreciate your help. Thanks in advance.