J
Jack
Hi there,
I am a beginner and am building a database to track the breeding of
experimental mice. I have two tables. One is called mice that has the
following fields:
mouse ID (primary key, autonumber)
strain
sex
date of birth
in breeding? (yes or no)
the other table is called breedings that has the following fields:
breeding ID
male mouse (foreign key to join to mouse ID)
female mouse (foreign key to join to mouse ID)
wedding date
divorce date
I'd like to have some automation to generate the new records in the breeding
table. Ideally when I click on the male mouse button, it will show the strain
list box and then click on one strain will show all available mice and click
on the individual one will put the mouse ID automatically into the male mouse
filed of table. then I can choose the female in the same manner. by selecting
the individual mouse, it should also update the "in breeding" field in mice
table. When I stop a breeding it should also update this field again.
The general idea is to avoid dealing with mouse ID which has no obvious
meaning and is prone to error when generating the new record manually.
Eventually I'd like to use this database to plan for breedings and can print
out a request that will set up breeding for a particular male and female.
once the breeding is physically set up, one would come back to database and
click "done" and a new record is generated in the breeding table.
Any ideas would be highly appreciated.
Thanks,
Jack
I am a beginner and am building a database to track the breeding of
experimental mice. I have two tables. One is called mice that has the
following fields:
mouse ID (primary key, autonumber)
strain
sex
date of birth
in breeding? (yes or no)
the other table is called breedings that has the following fields:
breeding ID
male mouse (foreign key to join to mouse ID)
female mouse (foreign key to join to mouse ID)
wedding date
divorce date
I'd like to have some automation to generate the new records in the breeding
table. Ideally when I click on the male mouse button, it will show the strain
list box and then click on one strain will show all available mice and click
on the individual one will put the mouse ID automatically into the male mouse
filed of table. then I can choose the female in the same manner. by selecting
the individual mouse, it should also update the "in breeding" field in mice
table. When I stop a breeding it should also update this field again.
The general idea is to avoid dealing with mouse ID which has no obvious
meaning and is prone to error when generating the new record manually.
Eventually I'd like to use this database to plan for breedings and can print
out a request that will set up breeding for a particular male and female.
once the breeding is physically set up, one would come back to database and
click "done" and a new record is generated in the breeding table.
Any ideas would be highly appreciated.
Thanks,
Jack