RE: [MS_AccessPros] Look up tables

 

Jim,

 

I’m glad you followed your gut instinct and stayed with your design. It would be interesting to know your advisor’s reasoning for avoiding lookup tables and what he suggests as an alternative.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Saturday, August 20, 2016 4:07 PM
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Look up tables

 

 

http://access.mvps.org/access/lookupfields.htm

 

You don't need to define lookup fields in tables in order to use  combo boxes on forms.

 

Duane

---

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sat, 20 Aug 2016 19:54:53 +0000
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: "Glenn Lloyd" <argeedblu@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

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.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___