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

Nice!  You know I always found making Access databases to be a lot of fun.
Still do.  And it pays well into the bargain.  I'm doing one now that I took
just for those reasons.  Also the apps tend to be interesting.  This one is
for a company that works with genetics.

As the Access market is shrinking it's getting harder to get the jobs but
you've got such credibility in your resume I'll bet people would hire you
just to have 'the expert' on their team.

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 12:30 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com