I have a field with unique values which are our job numbers. When I search for a value 12101206 in a field called jobNumber, my result brings up 12081707 and 12101206 in my found set. 

 

If I do a search for 12081707 is says no records found.

 

The field options are as follows...

Indexed, Auto-enter Data, Can't Modified Auto, Always Validate

 

I don't even know what I should ask here. When I perform the search it is bringing up a record with a different value then what I searched for.

 

Any ideas?

You didn't mention the data type of the field definition and you didn't describe the auto-enter calc. Number? Date? Text?

I have not fully traced out what the original developer has going on. The auto enter is not done in the field definition. This is preformed by a script. It puts build the current two digit year, two digit month, two digit day, and two digit job of the day beginning with 01(job of the day).

 

It is a text field

 

The validation is just not allowing users to modify on entry.

Well, that doesn't match what you said in your first post, where you declared that it IS an auto-enter value.

 

Indexed, Auto-enter Data, Can't Modified Auto, Always Validate"

The value is not entered by the user but entered automatically by a script. I copied the field options. You can see field options below.

 

 

1. field options

 

 

 

2. Auto Enter Options

 

 

3. Validation Options

"Data" is checked in the auto enter options but no data is entered in the box. Validation is checked to "Always" but no validation options are checked. Neither of these makes sense.

Set the indexing off and then re-establish it by setting it to FULL.