Forum Discussion

JimLieder2's avatar
JimLieder2
Qrew Cadet
7 months ago
Solved

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...
  • MarkShnier__You's avatar
    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.