Discussions

Expand all | Collapse all

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

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

    Posted 05-23-2018 09:14
                                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.


  • 2.  RE: How to get the value of a field in one record in to the other record?

    Top
    Contributor
    Posted 05-23-2018 21:58
    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?


  • 3.  RE: How to get the value of a field in one record in to the other record?

    Posted 05-24-2018 08:53
    yes, It is like Field 1 will represent a category and Field 2 & 3 are the information about that category.