how to call same row data from different table?

[rnmishra90]

i have two different tables, first table "pending" and another one is "planning". pending table has 3 column [lot no],[item name], [qty]. there is a list of pending items and qty. now come to second table "planning", here is 10 column, [item name], [lot no], [qty] etc, when is select item name in planning table it shows the list of item name of 1st table, when i select an item from the list, i want the data in 1st table pending lot no and qty may fill automatically with selected row of item name. we can not use look up because same item name multiple time in that table . i want data specifically from selected item name.