Susan Harkins
ssharkins at gmail.com
Tue Sep 2 10:46:49 CDT 2014
It does work! :) I just made a silly mistake in the column widths setting. Susan H. > 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 >> > >