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.
