Place fields from different records at specific places on layout.
I have a layout that has a map as a background image. I have a table that contains records relating to areas on the map - farm paddocks.
I would like to put information about a given paddock on the map taken from the record for that paddock. e.g. the number of animals in the paddock and/or animals per acre (both fields of the paddock's record)
Seems impossible without collecting the information from each record in advance and storing it in another table with a single record and fields for each paddock, which is what I've done so far for animal counts.
If I could create new fields from a script I might have the flexibility to make this method more robust.
Is there are better way ?.