Lookup not looking up...?
I have two tables joined on a common field. (Serial 1 in Table 1= Serial 2 in Table 2)
When I change from one layout based on Table 1 to Table 2, I want to copy the Value of Serial 1 from Table 1 into the field Serial 2 in Table 2.
When I manually put the number in, then the other fields pop right in with the right values copied from Table 1. (Yes)
What I can't do is automate putting the value from Table 1 into Table 2... I've tried Lookup and Calculated Value... and automatic data entry...
Rather lost... thanks for any help...