I have a Products table with: Product name, Barcode (Key), supplier, etc.
Then I have a Sales table: with Product Name, Barcode, Date, etc.
In the SALES table I placed Barcode as Ref and Product Name as Text.
What can I do for the Product Name to be automatically Identified based on the Barcode.
I currently have the Product Name as text, with no formula or initial value. But it leaves the cell blank instead of generating the name of the product.