UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Problems Creating Lookup Field, Access 2007    
 
   
tina t
post Dec 5 2017, 05:20 PM
Post#21



Posts: 5,197
Joined: 11-November 10
From: SoCal, USA


QUOTE
I may be a little bit heretical on this one issue, but I always use a States table with just two fields: StateCode (ID) and StateName (Idaho). A two character text field is just as efficient as a 32 bit Long Integer...

i'm with you on this, John - we can burn together! ;) i can't think of any other tables where i don't use a surrogate numeric key; in tables that, by the nature of the data, will have limited records, i'll use Number data type with a Byte or Integer field size, rather than always defaulting to Autonumber.

hth
tina

--------------------
"you can't take the sky from me"
Go to the top of the page
 
John Vinson
post Dec 5 2017, 07:46 PM
Post#22


UtterAccess VIP
Posts: 4,146
Joined: 6-January 07
From: Parma, Idaho, US


QUOTE
i'm with you on this, John - we can burn together! wink.gif

Ok... I'm a heretic, you're a she-retic!

I'll plead prior authority: Ken Getz and John Viescas (and I'm sure others) do this too.

--------------------
John W. Vinson
Wysard of Information
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 04:52 AM