I am having trouble adding the first record to a table.

The record is being added using a APPEND BLANK. The primary key is populated using a stored procudeure called from the default value property of the field in the DBC.

Using the EXE with the runtime libraries:
Beginning with an empty table the first record is added to the table and can be seen using browse. However SEEK() will not find the record searching on the primary key field. The second record added shows up in a browse window and is found by SEEK(). The first record is found using LOCATE FOR; and by isuing reindex and USING SEEK().



Using the development environment :
The first record is added and can be found using SEEK() and all subsequent records are added correctly.


Why will a fox table NOT index the first record of a table?????