Hey!

This is my first time posting here, so I'm still trying to get the hang of this.

I just started learning FileMaker (my first database program) and I'm trying out simple scripts to perform actions to make my work a bit more efficient.

Basically I am writing a database to track part numbers and serial numbers of certain products that get sold daily. Basically I have on text field for input, that after I scan a barcode it determines whether the scanned input is a part number or serial number. It then takes the inputted text and moves it to either the Part Number Field or the Serial Number Field. After that it clears the InputField.

What I would like it to do is then move my cursor back to the InputField so I can immediately scan the next barcode (without creating a new record). But every time I try it, it goes to the next field.

I have the script triggering OnObjectSave as the scanner adds a Enter Keystroke after the scan.

Here is the script I am using:

Any help would be great!

Thanks!

How about;

If [ Length ( Runners::InputField ) = 9 ]

 Set Field [ Runners::PartNumber ; Runners::InputField ]

Else If [ Length ( Runners::InputField ) = 12 ]

 Set Field [ Runners::SerialNumber ; Runners::InputField ]

Else

 Beep

End If

Clear [ Select; Runners::InputField ]