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

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Lookup field in a table    
 
   
SteeleHawk
post Nov 18 2008, 02:19 PM
Post #1

UtterAccess Addict
Posts: 102
From: Midwest
What do you guys think of Lookup fields in a table? In other words, when creating a new field in a table in Design view, using the lookup wizard to make the list.

...As opposed to creating a seperate table with your lookup fields stored as text.

I vaguely remember reading somewhere that using lookup fields is not very good, as they tend to mess up queries.

Any suggestions? Are they fine to use?

What if the database is upsized to SQL? Will these lookup fields present problems?

thanks!
Go to the top of the page
 
+
theDBguy
post Nov 18 2008, 02:28 PM
Post #2

Access Wiki and Forums Moderator
Posts: 48,113
From: SoCal, USA
Hi,

Most experts say that they are not a good idea. See this link.

Hope that helps...
Go to the top of the page
 
+
SteeleHawk
post Nov 18 2008, 02:30 PM
Post #3

UtterAccess Addict
Posts: 102
From: Midwest
Thank you!
Go to the top of the page
 
+
theDBguy
post Nov 18 2008, 02:35 PM
Post #4

Access Wiki and Forums Moderator
Posts: 48,113
From: SoCal, USA
You're very welcome. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 06:15 AM