Same table-Pull info from one record to another

Table-Material Orders
FYI-The same [JOB NUMBER] is indicated on each of the records listed below
Record 1: [PAINT CHANGES] (text field) is entered on this record; [ORDER TYPE] (multiple choice field) is "Prime".

Record 2: [ORDER TYPE] is "DW" - Need information from Record 1 [PAINT CHANGES] to show on this record

------------------------------
BuildPro
------------------------------