Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have the users use a form to read barcodes off the products (where each entry into a form would be a record (record = a product barcode), and when the form is submitted, the box field would then check the value which the user maintained in that table and "hard write" that value (box number) to the field (which defines the box which the product was placed ) when the record is created in the main table?
Hope this makes sense...
I want to have a form where the users can enter more than one record at a time with the Box number on the form.. so that essentially when you submit the form, the total number of barcodes read would be assigned to that one box.. but from what I understand you can not do that.. so I am trying to see what can be done to mimic the capability in some way..
Products need to be at the record level as there are certain track and traceability and reporting pieces which are needed which reflects the design.