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

Question

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Field1&nbsp; &nbsp; &nbsp; &nbsp;Field2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Field3(Record #1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;ABC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;(Record #2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;ABC(Record #3)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GHI&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;GHI(Record #4)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;GHIIn 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.

archiveuser · Answer

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?

vivekvishwanat3 · Answer

yes, It is like Field 1 will represent a category and Field 2 &amp; 3 are the information about that category.

Forum Discussion

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

Related Content

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Record Details

Many parent records on a single child record

Copy Records Step - Skipping All Records