Calculating a barcode entry

[MikeQ]

I am trying to set up a simple inventory control list using a barcode reader.

I can

[ernst]

Hi Mike and welcome to the forum,

MikeQ said:

.... if it is a new item place it in a new field.

Suppose you mean a new record as opposed to a new field?

Anyway, you could achieve this quite easily by entering the scanned value in a global field.

If the scanned value in the global field equals the scanned value in the current record then add one to your 'amount' field, otherwise create a new record, enter the global value in the appropriate field and set the amount to one.

Hope this helps,

Ernst.

[stanley]

Ernst:

I think you skipped a step. Read the barcode scan into a global field, then do a find in the barcode field using the same data. If no record is found, create a new record and put the data from the global field into the barcode field. If a record is found, increment quantity by one.

The idea being that you can't assume the user is already in the correct record.

-Stanley

[ernst]

stanley said:

The idea being that you can't assume the user is already in the correct record.

Hi Stanley,

If the scanned article is the same as the previous article then the user *should* already be in the correct record, because that record was created when the previous article was scanned.

But if Mike also wants to accumulate the count for each article when a user first scans article A, then article B and then A again, then you a totally right.

Then a lookup (or a find) should be performed with a concatenation of the scanned value (article code) and something like an invoice number.

Regards,

Ernst.