Hello

I am creating a database for the fish I keep and breed. I have a table and each fish has an ID number. I have fields for date of spawning and number of fry produced. The problem is that if some fish breed more than once, how do I list the dates so that if I do a Query asking for fry numbers and dates, all the different dates that a fish has bred will be shown with the same ID number.

Hope that is clear. Thank you.

You need 2 tables

tblBreeds
Breedid (Primary key)
Breed



tblSpawnings
Spawningsid (Primary key)
Spawndate
Breedid (Foreign key to tblBreeds)
NoofFry

Robert

Thank you very much Robert.

You're welcome.