Time series data
Hi, I am new to FMP and databases in general. I have set up a database for collecting data about trees. Each tree is given an ID number (generated serial number) and then various data is recorded for the tree and individual branches using FMGo, see screen captures below.
The problem is, I will later return to the same tree and record the same information again, and need to be able to compare the observations made at different times. The common information is the tree ID. What is the easiest way to set this up? Create new fields for the 2nd (and each subsequent set) of observations?