JimLieder2
7 months agoQrew Cadet
Snapshot calculations
I have a master price table containing part numbers and customer prices and a child table that adds parts to a customer work order table. I set up a snapshot field to in the child table to capture th...
- 7 months ago
No problem. This is a normal problem with snapshot fields.
What you should do is have a formula of the checks if the record ID is greater than zero. If that is true, then use the snapshot field, else use the look up field.