we want to search a product in a database by scanning the barcode.
It looks like, the barcode scanner can only add ean codes to the database.
Is it possible to search the name in the database with that ean code?
Or can you make a function for it that search for the ean code in the database and returns a name?
Have a field so that the barcode scanner can “scan” into that field.
Use a relation to relate the result to the table where you store all barcodes and names.
If you want to display a list of matching results, make that relation multiple, and show them in an inline list.
If you want to display a single name (in case all things are unique, I assume this is the case), create a lookup on top of the single relation and return the name.