Basically we have two workspaces. One is for project management. The other is for accounting. Once the project has been completed, we change it's status to "ready for accounting" which then automatically syncs with the accounting workspace. So no new records are being created in the accounting workspace.

We then generate a "price code" based on the company name and the product. The price code reference a price list which is a different table in the accounting workspace. I have nearly all the mechanics of this worked out, but currently have to manually copy/paste from "price code" column to "price" column (see screenshots). I'd like to automate this, but I've had trouble with the tutorials I've seen, and I also don't know what an appropriate trigger would be.

Thanks in advance for any help!