Rounding errors probably (hopefully!) wouldn't crop up, since you are
only going down to 2 decimals, and not really performing any
mathematical operation on them.

You might also consider a Char() field type, in which case
the 'STARTS WITH' clause may be handy for something. eg find record
1234 from any database might be STARTS WITH '1234.'.

In either case I don't think performance would be hurt very much by
using one or the other. I tend not to use and decimal point number in
a key field, probably because you couldn't do it back in the days of
Paradox.

Good luck!

Paul.


--- In IBObjects@yahoogroups.com, "Matt Nielsen" <mnielsen@c...>
wrote:

> I was planing to add the DBID in addition though. What sort of
> issues might I have with the numeric field?
>