data dispaly based on data selected on listbox

[hhhh]

HI Team,

Hope you are doing good.

I have two tables table 1 contains product files which is having apple,mango, bananna...

and second table contains like below 

item,sales,comments

apple,10,lesscost

grape,20,medium cost

orange,30,high cost

mango,40,very high cost

now my question is if i select on product list box(Apple) then one table show display which is having only apple information from second table.

for example: 

i am having mango data in first table filed.

if i selected  mango then mango show display from second table.

Can you please help me here on priority.

Thanks in advance 

[rwunderlich]

Assuming the field is named "item" in both tables, the association and filtering will be automatic. 

-Rob