3 Replies Latest reply on Jul 31, 2012 3:39 PM by robdownunder

    Place fields from different records at specific places on layout.

    robdownunder

      Title

      Place fields from different records at specific places on layout.

      Post

      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 ?.

      thanks.