"Should I create a different key field so the records from one table to the other won't dissapear in case I need to change the barcode?"
Yes. 100% absolutely yes.
You can create as many label fields for searching, sorting data as you need just keep your primary key (a simple auto-entered serial number works well) completely untouchable.
Thank you so much. That fixed the problem!!