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

Rocky, I redesigned my main table a bit -- the one storing animal
attributes and created several lookup fields at the table level. Then, I
let Access generate the form -- perfect. While I do understand the
arguments against using all of the great user tools, I sure don't mind
breaking all those old rules. :)

I will have the main functionality ready soon and then we can start adding
all the bells and whistles that she wants. I am going to be a hero. :)

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
>