np.
Snapshots to the rescue
https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.htmlPost back after you read that help text if you are stuck.
I assume that you have a Parts Master and there is a relationships where 1 Parts Master has many Parts Order Lines.
Basically all you do is to rename your current lookup field [Price] to be suffixed Price (lookup)] - that is what i do so I don't get confused, and then set up a new numeric field called [Price] (which is not a lookup field) and at the bottom of the field configure it to be a lookup and remember to update all current records!
Then use the Usage Tab on [Price Lookup] to find all places it was used in formuals and replace it with [Price], for example you will no doubt have a field for [Extended Line Price] with as formula of [Qty] * [Price (lookup)], so that will need to be updated to [Qty] * [Price]
