Is it possible to automatically insert a value from a previous record into a different field in a new record through a query? Through my research I have found it is possible to do this if it is in the same field, but havent been able to find the answer for a different field.
If so, can someone please explain how? Thanks in advance.
If so, can someone please explain how? Thanks in advance.
