I’m reworking my cattle database for Panorama X. I want to record the calves produced by a cow over her reproductive life. In Panorama 6, I simply recorded the calves as individuals in the database with ‘x’ as their mother. I would search the database for beasts mothered by ‘x’, and then return to my previous selection when I was done.
As Panorama X tends to search more slowly, I was thinking I’d record the calves in the mother’s information, only transferring them to the database themselves if they were kept. I had visions of creating a field in which I stored a preformatted array, which would be added to as subsequent calves were born, and which could automatically be viewed as a table in a form (DOB, M/F, description). Having scoured the help pages and examples, learning about arraycolumns etc, I still haven’t figured out anything remotely looking like working. I’m not sure whether this reflects my lack of programming knowledge, or just that I am imagining an impossibility.
The other way I thought of saving the data was as line items (DOBΩ, M/FΩ, descriptionΩ), but I actually haven’t figured out how to present this in a table either, unless I manually make one of Text Display objects, set out as a table.
Any suggestions on either
- how to do what I am wanting to do
- other ways of approaching the task
would be greatly appreciated.