I have a base with a "Workorders" table, to that workorder I would like to be able to add parts from my "Spare parts" table by scanning the barcode of that spare part (instead of writing in the search box).Each spare part has a barcode field with their unique barcode.
Is this possible? At the moment I can't see any other way to link to a record then to manually type and find the right part.
As there are so many parts in play with similar names, being able to find them by their barcode would be great help.
Anyone know if this is even possible?