Cargoplex Posted March 31, 2004 Posted March 31, 2004 I have recently taken on the task of switching our databasing needs from MS Access to Filemaker Pro in my office. I work in a sound lab for an audio preservation/restoration company, so our databasing needs are fairly light. In Access, all we do is enter inventory for individual projects (ie item numbers, recording times, etc.) and then print specific labels from this information (reel box labels, CD inserts, etc.). After having created my first database in Filemaker Pro, I am stuck in just one area: How to set up a print query for printing labels. All I want is a way to control what records are printed when I select a label layout and click print. In Access, the Table had a print checkbox that controlled which records showed up in the various label layouts. Not knowing how Access performed this exactly, I have no knowledge of how to mirror this in Filemaker. If anyone can help me out on this issue, it would be very much appreciated! Thanks! Version: v7.x Platform: Mac OS X Panther
Reed Posted March 31, 2004 Posted March 31, 2004 You could create a number field called "print" and create a value list with one value "1"... Then place the print field on a layout and format it as a checkbox group using the value list you just created. To choose which records you want to print, just check the box. Then find records where the box is checked and then go to your label layout and print. Hope this helps, Dana
Cargoplex Posted March 31, 2004 Author Posted March 31, 2004 Thanks Dana! I had that on the tip of my brain but just couldn't quite get it out. I set up the value list like you said and it works like a charm. Now, is there any way that I could easily check or uncheck the 'print box' for all records in Table List view that you can think of? Thanks again!
Recommended Posts
This topic is 7534 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now