billing app - add product via search or barcode

billing app - add product via search or barcode

hello,  

We have created a billing app.  

On invoices, we wish to add products in 2 ways:

- by search (drop-down list) on the field "Product_name"
- by scanning a barcode on the "reference" field. (smartphone camera)

We would like:
- if we enter the field "Product_name", the field "reference" must  fill automatically
- if we scan a barcode for the "reference" field, the "product_name" field must  fill automatically

The 2 fields must be both in "input" mode and "get data" mode.

Finally, the "price" column must fill automatically according to one or the other of these fields.

Can you help me
thank you in advance