Since the field of record has no data type requirement, you can assign any value. To assign the value to another record, you can conveniently implement the foreign key reference.
After executing the derive command, in the TSeq of EMPLOYEE, the value of StateInfo field is the record of TSeq of A2 on which you can double click to view the StateInfo field:
In the TSeq or RSeq, you can sort the record according to the specified conditions. With the sort() function, you can re-sort the records in the TSeq, and return the RSeq after sorting.