need autonumber-like sequence

[fullyfactored]

I hope this group can help me with a problem I have for a plant-
breeding program db I am building. In order to answer some anticipated
questions, here’s a brief overview.

1. Just like Mendel’s peas, we start by making a hybrid that has 50%
contributed from each parent and brings together the genes from both
sides, which control the traits in which we are interested.
2. After that, we rely on recombination and segregation (remember
meiosis?) to generate the variation, and within which we make the
selections that best display our desired characteristics.
3. We repeat this process or “cycle” each generation at several
locations or in different regions across the county.
4. Plants grown from seeds of a SELECTION maybe evaluated in
subsequent year(s) in one or more such locations; more than one if
there is plenty of seed.
5. We make selections and then selections-within-selections for
several years or until our selections reveal little or no new
variation.
My problem: How can I automatically assign a sequential number for
every new selection? It should be numbered 1, 2, 3… n, etc. for each
selection within each selection and restart each selection cycle?

Tables:
LOCATIONS: The unique areas chosen to evaluate a selected group of
SELECTIONS (County A, County B)
PLOTS: The physical spaces assigned to an individual selection, made
in another year, for evaluation;
CROSSES: The individual combinations of parents (like A x B, A x C,
etc.) that typically lead to repeated series of selections.
SELECTIONS: A single individual plant selection within a specific
CROSS.
TRIALS: A group of SELECTIONS grouped for evaluation at a particular
location; e.g. assigned PLOTS 1-198.

Sorry for a long question. I find it hard to explain.

Thank you.
Sam

 

[Joan Wild]

I don't see any need to restart the numbering sequence in each generation. I've done a tree breeding database and just went with an autonumber.

Selections - individuals - one of the field identifies what 'family' the selection was taken from, and also include a field for the 'generation'; every selection has a unique number.
Families - or crosses as you've called them. I take it you are only doing full crosses? No open-pollinated crosses or half-sibs? Each family gets a unique number, and is identified by the two selections that are the parents.

#4 - You are actually growing seeds of a FAMILY (not a selection). So you'd identify the outplanting by the family number, replication, row, column type of information to identify where each family was planted. Subsequently, you'd be selecting individuals from this family for next generation breeding (these newly selected individuals would get their own new selection id)

So a selection is crossed with another selection to create a new family. That family is tested and new selections are made within that family. These selections are crossed with other selections to create new families, etc, etc.

As long as you include the generation number, and the family the selection came from, you can trace back the parentage.

You might want to look at
http://allenbrowne.com/ser-06.html

--
Joan Wild
Microsoft Access MVP
I hope this group can help me with a problem I have for a plant-
breeding program db I am building. In order to answer some anticipated
questions, here’s a brief overview.

1. Just like Mendel’s peas, we start by making a hybrid that has 50%
contributed from each parent and brings together the genes from both
sides, which control the traits in which we are interested.
2. After that, we rely on recombination and segregation (remember
meiosis?) to generate the variation, and within which we make the
selections that best display our desired characteristics.
3. We repeat this process or “cycle” each generation at several
locations or in different regions across the county.
4. Plants grown from seeds of a SELECTION maybe evaluated in
subsequent year(s) in one or more such locations; more than one if
there is plenty of seed.
5. We make selections and then selections-within-selections for
several years or until our selections reveal little or no new
variation.
My problem: How can I automatically assign a sequential number for
every new selection? It should be numbered 1, 2, 3… n, etc. for each
selection within each selection and restart each selection cycle?

Tables:
LOCATIONS: The unique areas chosen to evaluate a selected group of
SELECTIONS (County A, County B)
PLOTS: The physical spaces assigned to an individual selection, made
in another year, for evaluation;
CROSSES: The individual combinations of parents (like A x B, A x C,
etc.) that typically lead to repeated series of selections.
SELECTIONS: A single individual plant selection within a specific
CROSS.
TRIALS: A group of SELECTIONS grouped for evaluation at a particular
location; e.g. assigned PLOTS 1-198.

Sorry for a long question. I find it hard to explain.

Thank you.
Sam