I am trying to manage somewhat small scale inventory/supply management. I need to receive supplies that have details attached, consume some supply to a process (linking some of the details) and also calculate the reduction in supply from on-hand stock.
In order to do this I am finding I need at minimum 2 tables. I have been able to get everything to work except scanning the consumed item to process. The consumable is the linked field and is the barcode (primary field on source table). The only way to add the record, however, is with text. The same function in the search field would be very helpful for the entry ui of the linked records (little camera icon opens the camera and acts as the input device)