field types

[w]

Hello, I just have a quick question. For the field types
that are ID numbers (but not actually calculated values),
should I set their field type to a text field instead of a
numeric field? Also if I have a lookup table with states
initials(text field), state names(text field), and region
number(like all states in the west have a regional number
1 for example), should the region number be a text field
instead of a numeric field?

Thank you!

 

[Kelvin]

Doesn't matter. Just as long as you are consistent. Number take us less
storage so your database will run a little faster.

Kelvin

 

[Tim Ferguson]

Doesn't matter. Just as long as you are consistent. Number take us less
storage so your database will run a little faster.

It also makes a difference how many regions there will be -- region "11"
will sort before region "2", which may or may not be right for the
application.


B Wishes


Tim F