Sabtu, 20 Agustus 2016

Re: [MS_AccessPros] Look up tables

 

I remember doing that in a college class learning about Access. I forgot about those lookup fields.

I want to learn more about SQL so I am trying to figure out how to convert my tasks and projects database to a SQL backend, so I asked the question, and the table issue came up. I know I have a lot of work to do to get my tables ready for SQL. The database is a constant work in progress, so some things have changed over the years and Normalization has not been kept up.

 
Jim Wagner


On Saturday, August 20, 2016 1:25 PM, "'Bill Mosca' wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Jim – You're doing it the right way. I have lookup tables for every item that needs commonly selected items. As you mentioned earlier, it provides more accurate spelling and limits choices. Every foreign key usually requires a lookup table for a form.
 
For instance, I have an application that stores all information on each application our company uses. One of the items is the server name associated with the app. Server details are filled in on a server form. The main App form has a sub form for a many-to-many server relationship. An app can have several servers. The user fills out the app info and selects the server from a combo box. It shows the server name but the table stores the server ID as a foreign key.
 
Regards,
Bill
 
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, August 20, 2016 12:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Look up tables
 
 
I was referring to my own combo boxes with the tables as the record source and it was clear that that meant too many tables to have in the design, I suppose.
 
But I do not know of any other way to get a select list of choices into a combo box without using lookup tables. So I stayed with my design and ignore his comments.
 
 
Jim Wagner

 
On Saturday, August 20, 2016 12:05 PM, "'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
 
 
Jim,
 
Was the developer perhaps referring to lookup fields, rather than lookup tables? Most developers agree that lookup fields are poor design.
 
Glenn
 
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, August 20, 2016 2:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Look up tables
 
 
Hello all,
 
A developer recently told me that using lookup tables is bad design. I argued that it is not possible to have drop downs on a form without having some data associated with the dropdown so users do not make spelling errors for one. it gives users limited choices, so they do not have the wildest things typed.
 
I began thinking how would anyone have combo boxes without lookup tables? What do other developers do especially SQL backend users?
 
Thank You
Jim Wagner
 
 


__._,_.___

Posted by: Jim Wagner <luvmymelody@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (8)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar