A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using Lookup fields



 
 
Thread Tools Display Modes
  #11  
Old January 29th, 2009, 06:22 AM posted to microsoft.public.access.tablesdbdesign
Jeanette Cunningham
external usenet poster
 
Posts: 2,190
Default Using Lookup fields

typogarphical - sounds like a new species of dinosaur or shark?

Jeanette Cunningham


"John W. Vinson" wrote in message
...
On Wed, 28 Jan 2009 23:36:48 -0500, strive4peace

wrote:

Excellent dissertation, Albert!

... although I am still wondering what a 'reocrdsets' is smile


A typogarphical error I presume.
--

John W. Vinson [MVP]



  #12  
Old January 29th, 2009, 09:07 AM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default Using Lookup fields

"John W. Vinson" wrote in message
...
On Wed, 28 Jan 2009 23:36:48 -0500, strive4peace

wrote:

Excellent dissertation, Albert!

... although I am still wondering what a 'reocrdsets' is smile


A typogarphical error I presume.


.... or a speeling mistook

  #13  
Old January 29th, 2009, 11:04 PM posted to microsoft.public.access.tablesdbdesign
troy23
external usenet poster
 
Posts: 55
Default Using Lookup fields

It is fine to use them and as long as your database follows relational
design there should not be any issues. Instead of having lots of
lookup tables it is possible to put all lookups into one table.

For FREE Access ebook and videos click here
http://access-databases.com/ebook

On 28 Jan, 02:59, DumbWithData
wrote:
Is it bad design to use the lookup field data value in tables? *If so, why? *
Is it better to use these in forms?


  #14  
Old January 30th, 2009, 10:07 AM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default Using Lookup fields

"troy23" wrote in message
...
It is fine to use them and as long as your database follows relational
design there should not be any issues. Instead of having lots of
lookup tables it is possible to put all lookups into one table.


And your comments on lookup *fields*? And please don't spam this NG.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:14 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.