Form to Create Multiple Records

[panza1370]

Hi AF,


I maintain an Access database for a lab that experiments with mice. Every day new pups are born and we enter their information into our database which includes the following: ID# (Unique Key), Experimental_Condition, Date_Of_Birth, Mother_ID, Father_ID, and Genotype. For each litter born, all the pups of the litter will have identical information for all of the fields except for Genotype (which is determined several days after birth and initial entry). Because we work with so many mice, it would be a great time saver if I were able to create a form that would take the experimental condition, mother, father, date of birth, and litter size and create multiple records in our database based on the litter size, as opposed to having to enter the same information independently for each pup of a litter. Any help with this would be GREATLY appreciated.

Thanks,
Adam

[June7]

You could have table for Litters then a related child table for the individual pups and their specific info. Consider:

tblLitters
ID (primary key)
Experimental_Condition
Date_Of_Birth
Mother_ID
Father_ID

tblPups
ID (primary key)
LitterID (foreign key)
Gender
Genotype

Then use form/subform arrangement to synchronize the related records. Main form bound to tblLitters and subform bound to tblPups.