Find bringing up a record I did not search for

[GregInChrist]

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?

[bruceR]

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

[GregInChrist]

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.

[bruceR]

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"

[GregInChrist]

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

[Rick Whitelaw]

"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.

[IdealData]

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