Make auto fill form a part of table

  Kiến thức lập trình

I have a table (table1) then is my data table same as below

and I have a form then that have a table inside it same as below

I need when I enter the “POD” from “Table1” in “POD”(B1) in “Form”, the “Table2″(inside “Form”) fill by data from “Table1”. this may 1 row or multi row data. and I don’t need all columns from “Table1”

Thanks for your solution
Best Regards

I try Xlookup , match, find, filter and anything I know
but I didn’t find anything

New contributor

Alireza Andalib is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.