|
|
Posted by pde1contact on 03/10/06 17:09
I find it helpful to have a contry ID field that is standardized. SAy,
three-letter code. Then you can use the country name field for display
and unimportant stuff, but when you want to be sure what you're doing in
the code, you do operations and queries with the ID field. makes the
database more efficient and faster too.
-- PD-man.
toedipper wrote:
> Hello,
>
> Imagine I have a table called countries. Every country is the world has a
> unique name so should my table just have one field called ie CountryName or
> should I have 2 fields including eg Countryid?
>
> I mean, if the countryname fields are unique anyway what is the point of
> creating an id field? It just seems to me to create extra baggage.
>
> I'm all new to this so someone point me in the right direction!
>
> Thanks,
>
> td.
>
>
>
>
>
>
>
Navigation:
[Reply to this message]
|