How to get the value of a field in one record in to the other record?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
                            Field1       Field2         Field3
(Record #1)          11               ABC            ABC           
(Record #2)          11                                  ABC
(Record #3)          12               GHI             GHI
(Record #4)          12                                  GHI


In the above table, I have 3 fields. Field1 is ID(or any numeric field), Filed2 is a text Field.

I need Field3 to be showing ABC in the record 1 and Record 2. and GHI in record 3 and Record 4.

To rephrase the same question. I need the Field 3\record 2 should be fetching the value from Field2\record 1.

Please Help me.
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Are these records related in any way or is this more like something where Field 1 would represent a Category and Field 2 and Field 3 would be information about that category?
Photo of Vivek Vishwanath

Vivek Vishwanath

  • 474 Points 250 badge 2x thumb
yes, It is like Field 1 will represent a category and Field 2 & 3 are the information about that category.