Hello,

I need to scan in about 10,000 barcodes and would like to be able to do this without touching the keyboard. How can I have FileMaker create a new record, enter generic data in 2 fields, go to my target field, wait for input from the scan gun, then repeat the process?

I can do the generic data fields entry and create records but can not figure out how to tell FMP to wait for data in a field, wait for the "RETURN" to be entered by the scanner, and then create a new record to continue.

I have been using the scan gun in Excel for 4 years and programmed it to go to the next row after entering data so I am familiar with programming keystrokes in the scan gun.

I am using FMP 8.0 Advanced in XP

Thanks much

Do it within a script?

You can always still use your Excel and then import the data into FileMaker as well.

You can either:

- make a looping script with a Pause step; your scan would end with the Enter key to continue the script

- or, put your script at the top of the Scripts menu; your scan would have a prefix of ctrl-0 through 9, depending on your script order.

(If it was only one field, you could prefix the scan with ctrl-N; make sure first that you're on the right layout and the barcode field is first in your tab order.)