Sam said:
The last number row of the 'Color' Column is 12. When I enter a new color it is placed in row 101.

I’m not sure what you are telling us here.

Is ‘Color’ a field in ‘Dynamic Field Data’?

On your case, its easier tu use text value, not number.

Try this code to inspect the selected option by its name :

let xChoice := 'New Data';
let xType := text('Field Name Choice');
let i := (create 'Dynamic Field Data');
switch true do
case xType = "Color" :
    i.(Color := xChoice)
case xType = "Height" :
    i.(HEIGHT := xChoice)
case xType = "Single lettre" :
    i.('Single Letter' := xChoice)
case xType = "Number" :
    i.(Number := xChoice)
case xType = "State name":
    i.('State Name' := xChoice)
case xType = "State abbreviation":
    i.('State Abbreviation' := xChoice)
end;
'New Data' := null;

1 - In line 2, replace number('Field Name Choice') with text('Field Name Choice')
2 - Make sure that the comparison text is exactly the same as the dynamic choice list.

Sam said:
yes they are fields in the table. There are 100 number records. There are 12 colors. When I add a new color it gets positioned in number 101. Add another record that is color or other and it is positioned in 102.etc
There are 21 fields. The largest is 100. So, as each field has new data, the table grow quickly.

 Sounds like you may want to consider a sub, or child, table to your Dynamic Field Data table. You will be creating a 1:N (One to many) relationship. Where 1 record in Dynamic Field Data is related to many records in the new child table.

So the root, or parent, table just has the names of the fields, Color, Number, Height etc. Then you create an entry in the child table that links to the parent record where you keep track of how many of each parent table record you need.

Take a look at this video for more about relationships.