Im just the grunt labour round the place, its my wife who does the important stuff! - but am trying to tailor farmOS to replace the multiple *doc forms that she produces ATM.(and trying it out with historical data)
I added 2 fields to the animal form - 2019Tuppingdate and 2019Tup.
I assume I can link the 2019Tup data to the lineage when the lamb(s) appear.
And produce a table of lambing dates as TuppingDate+147 days
And next its 2020 .
If I delete my 2019Tuppingdate and 2019Tup fields to replace with 2020Tup & 2020 Date does it also wipe the tables with the 2019 data ? thats what the warning implies , so ive not done it yet
If so id be best having a ‘Tups’ data field and leave it . But its convenient to look back and see who has been used in previous years (weve got a limited genetic pool to work with - http://www.orkneyboreray.com )
And the next bit is to produce for the Tups field a list of the equipped rams
(Select from animal where Sex=“Male” AND Equipped NOT LIKE “Castrated” …sort of thing )But I suspect its a LEFT JOIN on cursory glance at the many tables.
if the data is wiped ill just have a bit of the form for archived inputs - that we dont look at again