AnsweredAssumed Answered

Lookup not looking up...?

Question asked by cheathamtech on Jan 27, 2011
Latest reply on Jan 10, 2013 by gfischman


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...