I think your problem lies in the fact that you are using two different tables. I don't understand why.
I would think these two prices need to exist in the same table.
In that table a field for the "Framer Price" and a calculation field that adds 20% and gives you a Wholesale price.
Any changes made to the "Framer Price" are immediatly added to the "Wholesale Price".
Make sure that when you sell an artwork you do a lookup of the current wholesale price into a new record in an other table. Otherwise price changes will be reflected in sales records that have already passed. And that's never a good idea.
Yes I think you're right. I guess it will have to be a conditional calcualtion that looks to see if it is a loose print or framed print, and if it's framed add 20%. Does that sound correct to you?
I'm thinking you might be best of by having one table that contains the info about the artwork. And a related table for all the different versions or formats you can have of that painting. Look at the above file for an example.
It also looks at the Frame Type. If there is "No Frame" it just takes the cost. Otherwise it adds the markup that's in the Markup field.
It's set to 20% automatically but it can be changed per item.
Thanks for your help DaSaint. I appreciate you taking the time to make the example file for me. You've helped me out alot!!