Barcode to Show Stock Item

[TotalSolutions]

I have a Barcode Column in Stock Item Table which has Barcode and Stock Item Name.

I have Orders Table and in the Orders Form I have Order Date then Barcode Column which is Ref type and it refers to the Stock Item Table. I want to automatically Select the Stock Item when the user Scans the Barcode but for some items which don’t have a Barcode the user should be able to manually Select the Stock Item as well.

Please let me know how to do this.

Thank You!!