Re: re tobys comments

[Craig Sanders <cas@taz.net.au>]

> *    The State is held as ID in the State table but as 3 characters in
> other tables which use it. Perhaps a better option would be to use the
> StateID instead of the 3-letter state abbreviation.

yep, use the id field...that's what key fields are for :-)


> *    The PhoneNumber is stored using an integer. I have always understood
> that numeric fields were only to be used when the field woud be used in
> calculations. In this case I suggest that a text field be used.

yes, you need at least 18 characters for a phone field. at least, it was
18 characters several years ago...might have increased by now.

craig

--
craig sanders