MontyBurns
Programmer
Hi,
A simple qs here I hope, but one I've never really put much thought or research into.
If I only want to use a lookup table to, say, lookup a Country from a list, should I include an Autonumber field along with the country column (assuming there's no other columns/fields such as Currency)?
I assume this all depends on whether or not the values in the other column (e.g. Country) is unique, but can't find any hard and fast rule. I know that in most situations it's easier if you only have one field to consider, but...
I'd really appreciate any thoughts or advice from your experiences to date.
Thanks,
Burns
A simple qs here I hope, but one I've never really put much thought or research into.
If I only want to use a lookup table to, say, lookup a Country from a list, should I include an Autonumber field along with the country column (assuming there's no other columns/fields such as Currency)?
I assume this all depends on whether or not the values in the other column (e.g. Country) is unique, but can't find any hard and fast rule. I know that in most situations it's easier if you only have one field to consider, but...
I'd really appreciate any thoughts or advice from your experiences to date.
Thanks,
Burns
