Barecode and field

Good morning,

I would like to display in a field the value corresponding to a barcode.
I scan the barcode (in a reservation table), it will look for the product name in another table (product table) and it displays the name in the field.
How can we do?

Fred

https://help.appsheet.com/en/articles/2357309-lookup

Thank you