7 Replies Latest reply on Jan 11, 2017 6:34 AM by user19752

    Table needed for displaying field information


      I have a FM Pro database, and want to display information in a table-like way.

      Field name is "Block"

      Contains letters A-G.

      Field Name is "Instrument"

      Contains about 15 wind instrument names- ie "Flute", Bassoon, etc.

      800+ records


      Trying to create a layout that will display how many of each instrument are in each block.

      I'm guessing this is some kind of summary......................

      How many flutes have "A" for their block, how many have "B", etc.

      Then the next instrument "A" block, "B" block, etc.


      Instrument Field would go down the page

      Block A  Block B  Block C, etc. across the page