[AccessD] Looking for easy form solution

[Bill Benson]

Do Flocks and Herds vis a vis their individual animal constituents act like
parent and children in the sense that a parent has many children but the
children will only ever have one parent (you know what I mean, all Access
children are raised by single parents).

On Sat, Oct 24, 2015 at 10:48 AM, FW Salato Center <Salato at ky.gov> wrote:

> Here's the setup - I apologize if I'm giving more information than you
> guys really need.
>
> I have a table of individual animals. I have a lookup table of species.
> Each animal is identified by a species. I also have tables for medical
> records and vaccines, which relate to the individual animals.
> Updating medical records and vaccinations for individual animals is easy
> and already in place. I spent a full week going through paper records and
> inputting records for the last several years.
>
> However, we do have several multi-animal exhibits where the most efficient
> input solution for the vet and animal care staff is to pull up a  herd or
> flock option that initially selects all of that species and lets them make
> the medical or vaccine update for all. Rarely will they need to update an
> individual - but that will happen in the case of specific illness or
> injury. So, in the case of flocks and herds, we need a multiple-selection
> action type form. That form needs to be flexible enough that we can
> deselect individual animals because on rare occasionally, one or two of the
> herd or flock will not be part of the procedure.
>
> I need a form that displays all the animals of the same species - not
> difficult. I can do that.
> I want a select/deselect control that lets the user remove an animal from
> the group. Not sure about that one.
> After deselecting any individual as necessary, the user can then input the
> necessary medical or vaccine information - probably via a subform - and
> click OK to commit. I already have the forms that we're using to update
> these records for individuals. I'm wondering if I could use it as a subform
> in the multi-select main form? I'm not sure if this is something that the
> main/sub form arrangement can handle or if I'll need to create a Recordset
> object to update the  underlying tables.
>
> I'm seriously overthinking it because every time I start in with a
> solution, I change my mind. I could use a little strategic discussion on
> the best way to accomplish this. I prefer the easiest route and I can't
> help but think this should be simpler than I'm making it.
>
> Thanks in advance.
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>