I find myself using lookup tables more and more, both for data integrity as well as efficiency, and have a general question.
Is it better to have in my main table a lookupID field which will be linked to the autonumber field in the lookup table, or a text field which is populated as a result of looking up the lookup table if you know what i mean <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
The main difference is obviously that the field in the main table will contain only integers, which must be better from both a storage and sorting point of view.
At present, i am of the opinion that it does not really matter, but i am interested in what other more experienced users would consider the "best" or "better" way of doing things.
Thank you for your time.