Share
Report
89Hello. I could use some logic advice.
My final goal is to have a matrix table of plant and plant specifications, with columns for mother, father, comparison plant and comparison plant 2.
The specs are things like Harvest time, Plant shape, etc.
My final goal is to have a matrix table of plant and plant specifications, with columns for mother, father, comparison plant and comparison plant 2.
The specs are things like Harvest time, Plant shape, etc.
So Column A would be the specs. Column B would be the plant spec details, Column C would be the mother spec details, Column D would be the father spec details, Column E Comparison Variety 1 spec details, and Column F Comparison Variety 2 Spec Details. This report is the final result I want. The question is how to build this in the database?
Each plant has an assigned mother (same entity), father (same entity), Comparison Plant 1 (Comparison entity), Comparison Plant 2 (comparison entity.) Many plants can have the same mother or father, or the same comparison variety(s). The obvious problems are linking records within the same entity, or linking two records (comparision varieties) to a single record.
Each plant has an assigned mother (same entity), father (same entity), Comparison Plant 1 (Comparison entity), Comparison Plant 2 (comparison entity.) Many plants can have the same mother or father, or the same comparison variety(s). The obvious problems are linking records within the same entity, or linking two records (comparision varieties) to a single record.
Are there developed models that I could look at?
All responses (
Answers (
