yes your surmise is correct. One owner many boats and I 'm using ( well I will use) the Data assist package to create the search and update pages etc.
I tried to do as you said but when I set the field to numeric it accepts but when I save it alters the numeric field to decimal.
I've sql-dddd and ziped up the vast database ( ok two tables)
can you take a look and see what I've done wrong.