Additional guidance and thought: The solution for Attachments must contain the flexibility of linking to the attachment vs actually moving the attachments. I.e. the order number field vs the document no (along with some line numbers) so the attachment basically is re-linked or could have multiple links in an Attachment relation table.