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.