Do you have an example of the information extracted from a barcode? Depending on the output format from a scanned barcode, you may be able to scan the barcode into one field and have logic in other fields using functions like MID() and FIND() to get ...

In order to get the an auto sum of the number of items that the client is willing to buy it, and not use a publicly accessible client number as a linked record, You would have to go in afterwards, and associate/link each client created record with th...