[AccessD] Presenting data problem

<<Just the vaccination trackage should be a db of its own. :) >>

I developed a veterinarian package many years ago (I even went to the
national AAHA show one year) and it's not as difficult as one might think.
The biggest challenge I had was lab results, which for any given test, could
have any number of fields and values.

Based on that experience, my only comment would be to trend towards discrete
tables as much as possible in your design.  While the EAV design has its
uses, it has short comings as well.

Arthur's setup is a good in that your still using tables more or less, it's
just that you have multiple tables stored together and in doing that, save
yourself some work.  But really without much extra effort, you probably
could bust a lot of that out into separate tables.

I might also suggest that to cover the "loose ends", consider adding a
diary/comment system (ie. "Lab notes") with a keyword search on it.   It's
not typically something I like to do in a design because users start putting
everything and anything in there and it's all free-form, but sometimes it is
one way to get the job done.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, October 28, 2014 08:35 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Presenting data problem

James, it is a simple db when you consider the scope. We'll be tracking
about 50 animals from intake to death. Now, a lot will happen, so yes, it
isn't as simple as I first thought, but we'll never be dealing with a lot of
records -- just that each animal has a lot going on and all those details
differs from species to species. Just the vaccination trackage should be a
db of its own. :) 

I'm definitely recalling all the scope creep conversations we've had over
the years, but... I'm on the payroll so there is no such thing as scope
creep. The boss gets whatever she wants. :) 

Susan H. 


Susan,
I'm not sure that it is appropriate to start off the thread using the word
'Simple' ?
Convoluted or perhaps tortuous seem to be more appropriate the way you are
going with this. 
But I hope you are enjoying the experience. 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com