[AccessD] Let's discuss lookup tables a bit more

Susan Harkins ssharkins at gmail.com
Tue Sep 2 10:32:00 CDT 2014


Yeah, Rocky -- that's no problem at all.

I'm redoing the basic queries this morning and I decided to use the
built-in lookups at the table level for the lookup fields. I know, I
know.... but since I'm taking the easy route, seems a no-brainer to me. I
tried to get it to take a self join, but didn't work -- so I guess it can't
accommodate that one. I'm going to go do a bit of research just to make
sure.

Susan H.


On Tue, Sep 2, 2014 at 10:54 AM, Rocky Smolin <rockysmolin at bchacc.com>
wrote:

> I'd do it but you will need either a form where they can maintain the
> institutions table or a Not In List event for the box where they pick the
> institution.
>
> R
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Tuesday, September 02, 2014 6:34 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Let's discuss lookup tables a bit more
>
> After our discussion on normalization I've simplified the table structure
> in
> the animal tracking database quite a bit. I especially appreciated the idea
> that all animals have birth parents -- they just won't always be known.
> I've
> expanded that to cover institutions too -- all animals come from an
> institution, just sometimes, it's our own (ie, they're born here).
>
> But that brings me to an interesting possibility regarding the institution
> table. There won't be very many because we work with just a few in our
> region. I'm leaning toward thinking of the institution table as a lookup
> table. At least, I can use it that way, even if, traditionally, it wouldn't
> be. However, they'll need the ability to add institutions on the fly, but
> that's no big deal.
>
> Any warnings?
>
> Thanks!
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list