> If you were to design a relational database what would you key on? Would you
> assign hive bodies numbers? Things are so interchangeable I would wonder what
> the core of the record keeping would revolve around.
The main unit in my outfit is the bee yard. However there are other units of
interest such as hives and areas and treatments. Employees doing tasks and
dates are also of interest.
The DBs I have examined seem to be able to use multiple files and multiple
indices. I haven't gotten too far into it, but I was able to transfer my Excel
data into one and sort and report by any field.
I am assuming that I could set a good DB up to sort, search, filter, total and
report by any field and not be limited to one field as key.
allen