Sabtu, 20 Agustus 2016

RE: [MS_AccessPros] Look up tables


Jim – in case you don't know what Glenn is referring to, look-up fields are a way to view a field other than the foreign key within a table. For instance if you have an Orders table with a CustomerID, you can set that field to be a lookup field that shows the customer name rather than the key. It's really bad practice because the developer has to juggle stuff in forms and reports where they might need the REAL value of the field and not a built-in combo box.


Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT

My Nothing-to-do-with-Access blog


From: []
Sent: Saturday, August 20, 2016 12:06 PM
Subject: RE: [MS_AccessPros] Look up tables





Was the developer perhaps referring to lookup fields, rather than lookup tables? Most developers agree that lookup fields are poor design.




From: []
Sent: Saturday, August 20, 2016 2:10 PM
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: "Bill Mosca" <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

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