On Jun 24, 7:52=A0pm, Grip <g...@[EMAIL PROTECTED]
> wrote:
> On Jun 24, 5:41 pm, dh003i <dh0...@[EMAIL PROTECTED]
> wrote:
>
> > I have a database (gMouse), which is for keeping track of our lab's
> > mouse inventory. There is a Cages table and a Mouse Table. Within the
> > mouse Table, the different mice are assigned strains.
>
> > We can have breeding cages with 1 male and up to 2 females. I want to
> > also create a "strain" field in the Cages table, and have that result
> > be calculated, based on what the strains of the mice are in the
> > records related to that individual cage.
>
> > How can I do this? The issue here is I have a 1-to-many relation****p
> > (1 cage, with 2 or 3 mice), and my calculation of the "strain" the
> > cage belongs to depends on all of the mice that are in that cage (not
> > just the first one found based on sort-order).
>
> > Any help would be much-appreciated. Thank you.
>
> Presumably when you have two females, either the females are the same
> strain or you have some way of identifying their progeny. =A0I'm also
> assuming for each Mouse, you already have fields for *** and strain.
>
> To manage this, you need to add relation****ps and new TOs to filter
> the correct Mouses. =A0To Cages add two calculated fields, each with a
> text result, one =3D "Male" the other =3D "Female". =A0 Add two new
> occurences of the Mouse TO, using CageID and *** as your match
> criteria to CageID and each of you new calc fields.
>
> Now from Cages, you can see you male mouse and your female mouse/
> mice. =A0You don't say how CageStrains are determined based on the
> Strains of a cage's mice, but the above should set you off in the
> right direction.
Thank you. What I have is as follows (the strains):
C57
FVB
PDE1A
PDE1C
PDE3A
etc
The C57 and FVB strains are just background strains; we have them for
the purpose of cross-breeding, to get that background. Hence, if I
have a PDE1A mouse in a cage with a C57, I want that cage's strain to
be PDE1A. If a C57's with PDE3A, I want the cage strain to be PDE3A.
Likewise with FVB; in short, if there is a C57 or FVB mouse in a cage
with another strain, the other strain should determine what strain the
cage belongs to.
Would this be possible? Thanks.
|
