[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
>