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

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

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.


"the wheel never stops turning"
Go to the top of the page
John Vinson
post Dec 5 2017, 07:46 PM

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

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    23rd March 2018 - 06:07 AM