I hope this is a simple answer as I feel I’m really close to figuring it out, but just don’t have enough knowledge or experience to push it past the finish line.

What I would like to do is essentially move archive records to a new base for reporting purposes and security purposes.

What I have done thus far:

Built a search work rule to pull out all records in a Complete Orders view. This table contains linked fields to other tables to keep data integrity.

Built a create record work rule and mapped the fields.

This seems to work from a functional standpoint - meaning, it executes and seems to update the fields in the Archive Base, but the fields with linked records are just the record id and not the “human readable” text.

How do I get past this.

Any help greatly appreciated!

Jason