1 Reply Latest reply on Nov 26, 2008 12:40 AM by raybaudi

    Marking and printing a subset of records from a database

    Turlough

      Title

      Marking and printing a subset of records from a database

      Post

      A music teacher friend wants a setup where she can pull out and then print, let's say, 10 - 15 tunes from a base of maybe 150 tune lyrics and print out those selected tunes for students. Different sets of tunes for different students. Putting the tune lyrics into records is easy enough. In addition to the main layout where each tune is a record and each tune lyric and title separate fields, I assume I need therefore to make a list-layout, where each tune title (i.e. a record field) is on a line and beside the tune title there is a check box. The person scans the list, clicks the ones she wants, then clicks a button that assembles the tune lyric fields of the marked records into a new layout for printing. Putting the tunes into a fmp database is simple enough, just each tune is a record and separate fields for the tune lyrics and the title, plus a few other fields. But how to get a check box to identify and mark a record just stumps me so far. I am fairly inexperienced, but working my way through a mountain of vtc.com tutorials and making headway, but I hit the wall with this one. If someone could point me in the right direction I would be very grateful. Thanks, Turl. 

        • 1. Re: Marking and printing a subset of records from a database
          raybaudi
            

          Hi Turlough

           

          This is the way to go on with the checkbox:

           

          1) Go to File >> Manage >> Value Lists... >> New >> Value list name: "flag" Use custom values: 1
          ( you don't need more values than 1 )

           

          2) Go to File >> Manage >> Database... and add a new number field named: flag

           

          3) while in Layout Mode put the new field where you want and format it as a checkbox using the value list : "flag"

           

          4) Whatching the object info, set the dimensions of the field flag to something like 17x17 px.

           

          Now, when in Browse Mode, you'll have finally your check box.