data dispaly based on data selected on listbox

hhhh — Mon, 20 Jun 2022 13:29:07 GMT

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

Re: data dispaly based on data selected on listbox

rwunderlich — Mon, 20 Jun 2022 13:50:09 GMT

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

-Rob