Help with lookup
I have a field in a scheduling worksheet that I want to do a lookup for in a related table. The value is generally static with a yes or no value. If the looked up field is blank, a decision is made for that particular instance. When I enter a value, it also changes the value in the related record.
How do I keep the value in the related record from changing?
Thanks for any assistance offered.