Is it posible to lookup data from one table and insert it in another
I have table 1 with a code no and description fields I want to type in the Code no into a column in table 2 and have it look for the corresponding description in table 1 and input this itself.
I have tried a lot of lookup combinations ala excel but cannot get this correct
