Update a field in second form from Look Up
Hello
I have 2 forms that have a relationship through a lookup. I am trying to update a status field to complete when that record has been looked up. The lookup field is looking up an auto number from the first form.
Can someone guide me on this
Thanks
Amanda