Sales Order approval based on Project Partner assigned to the Project

Hello,

We have a create a custom field for project partner on project and when sales order is done for a project, the approval should be based on the field project partner which is assigned on the project.

Grateful if we can get a solution on how to setup the approval.