Snapshot for a look-up field?
Hello, I have a table that contains my sales reps and their commission plans. Whenever I generate a project in my projects table, it links the sales reps' commission percentage to each project....
Forum Discussion
Keep your original field as a lookup field, then make a new field labeled "Original Cost" or whatever you want. The new field should have a Snapshot section at the bottom of the field properties page where you can "Get this field's value from a lookup field and don't allow the value to change", then the next part allows you to select the lookup field you want to capture the value from.
------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------
------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------
