Help with Auto ID
For some reason a record was deleted from the database this is record 21 - As a unique ID this is linked to other tables in my database that make things work properly
So I had to recreate the record- But I manually then went behind the scenes and gave this new record the number 21 again so that it would not compromise all the records that had 21 previously
This all works now except when I am on this table and I click find it finds the record by the name but not by the auto id
If I type 21 on the auto id if finds 9 records all with the 21 starting so it finds 21, 212 ,213 etc
I cannot understand why
Can you help me
It means that this field is defined as a text field instead of a number field and thus is indexed and searched as though you have text in the field.