DETAILS Database data is internally indexed in a tree structure. The topmost node points to a number of nodes and these nodes can each point to the same number of nodes. Bottommost nodes point to the data. When all the bottommost nodes are full a new level is created at the top. Forms and SQL were not creating the new levels correctly when required. The example list stats shows two index levels with 84 entries in each block. This means that 84 index blocks can be stored in two levels (the top one block points to 84 index blocks) and 7056 index blocks can be stored in three levels (84 blocks each point to 84 index blocks). Here there are 85 blocks stored in 2 levels; the index levels should have been increased to 3. EXAMPLE PROGRAM Number of Index Levels 2 Max Entries Per Index Block 84 Index/Data Block Size 253/254 Active/Inactive Data Blocks 124/0 Active/Inactive Index Blocks 85/0 WORKAROUND If the active index blocks are filling up the level then update the database using dbms/pql for forms/sql through MASTER as this will correctly increment the levels.