Inventory app with barcode scanner for input/output

[pwncess]

Hi, I have an inventory app with an update log where I input/output new stocks. I'm having trouble with the barcode area. Whenever I try to add/deduct an item by using the barcode scanner, only the barcode of that item shows up, not the item. (As shown below..)

Or if I input manually using the item drop down menu, the barcode of that item doesn't show up.

Is there a way where if I scan a barcode of an item, the item name in that row shows up as well or vise versa?

I have tried using the lookup formula but it doesn't seem like it... Help~~

Thanks.

[SkrOYC]

Well, as far as I know, you can't go both ways. You either get the code from the item or the item from the code.
You could add an extra pair of columns and hide one or the other based on the origin input.

Well, related to your first problem, add an Initial Value on your Item column that looks for the ID of the item whose barcode equals [_THISROW].[Barcode]