What you’re talking about is actually not a FlowField (that does also work with option fields).
To “flow” to the archive, you want to create a “Field Transfer”, on the Sales Order field you have created, click “Field Transfers” and select the archive table. Then Simple Object Designer will create a new option field for the archive table and connect the two.
That did exactly what I needed. Thank you!