About ow many farm paddocks are you tracking/working with?
Secondly, is the layout with the map in the background used solely for presentation/dispaly purposes?
I have a solution where I put a zipcode map up on the screen and fields in front of it display a count of the number of invoices with a zipcode from that zip area are counted for a user specified time interval.
I used filtered one row portals to display data specific to each zipcode.
I think a similar approach may work for you. (Been trying to convince a brother that his farm needs a database and have previously thought of a similar approach where a map of the farm is broken up by orchard and data from each orchard would be displayed...)
rdowler: 15 paddocks and yes, it's presentation only.
PhilModJunk: Wow, I think you've solved it. I've hardly ever needed to use "filter" in portals before so the technique is not one that pops into my mind, but I now see it will help me in this case. Thanks Phil.