[AccessD] Presenting data problem

Susan Harkins ssharkins at gmail.com
Wed Oct 29 16:46:26 CDT 2014


Bourbon, neat, straight -- everything else is wasted calories and carbs. :)

Susan H.

On Wed, Oct 29, 2014 at 5:34 PM, James Button <jamesbutton at blueyonder.co.uk>
wrote:

> Sounds like you need a good whine session.
> :(
>
> Or maybe a good wine session
> :)
>
> JimB
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Wednesday, October 29, 2014 9:04 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Presenting data problem
>
> Well, I had a eureka moment about 4:00 pm. I've been struggling with these
> two lookup tables where dispositions are concerned. Every animal can have
> only one disposition id -- how it leaves the facility. But there are
> several disposition details that are possibilities -- so we hashed that out
> and I decided to just dump them all in the same table -- disposition and
> disposition details.
>
> But I still had two lookup tables to fit into the mess -- first a
> disposition description and then a death description and it finally hit me
> this afternoon -- death lookup is totally unnecessary, I'm just dumping all
> those death descriptions into the disposition lookup -- ultimately, they
> all describe the type of disposition.
>
> Man... it took me a few days to finally figure that out.
>
> I know why I stopped doing this now. :)
>
> Susan H.
>
> On Wed, Oct 29, 2014 at 1:43 PM, Charlotte Foust <
> charlotte.foust at gmail.com>
> wrote:
>
> > On Wed, Oct 29, 2014 at 5:02 AM, Stuart McLachlan <
> stuart at lexacorp.com.pg>
> > wrote:
> >
> > > I second that, I'm using a diary of date/time and username stamped
> > > comments more and
> > > more in systems I am developing. these days.
> > >
> > >
> > >
> > > ​I've been doing that for some time as well. I generally​
> >
> > ​have a notes table that contains a FKs and comment type fields or put a
> > Note field into a specific table, depending on the application design.
> >
> > Charlotte​
> > --
> > 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
>


More information about the AccessD mailing list