I have two Tables in the same Base.One field in the table (APPAREL) should look-up the value in another (SC APPAREL SYNC)Here is the Field (TEST2) in the APPAREL table which should look up the SAMPLE COORDINATOR in the SC APPAREL SYNCAs you can see, ...