agility

I am printing ID cards 4-up on a page. I have many hundreds of cards to print and putting them in order individually takes a LOT of time. I'd like to print them so the pages do not need to be sorted separately, but can be outputted in stacks. With a normal print, 16 cards would print on 4 pieces of paper like this: 1 2 5 6 9 10 13 14 3 4 7 8 11 12 15 16 I want to print them so the stack of output can be separated and have them already in order, like this: 1 5 2 6 3 7 4 8 9 13 10 14 11 15 12 16 I can't figure out how to script this. I am sure someone has done this before - can you share how? I am using Filmaker Pro 11. Thanks in advance!

You mentioned relationships - I had the portal file's box about allowing deletions CHECKED, and I looked in the files that work correctly and it was UNCHECKED. Seems backwards but I unchecked the box and it works correctly now. Thank you!!! --Sue

The FileMaker Knowledge Base says this: In order to delete a record represented by a portal row (a related record), check the 'Allow deletion of portal records' check box in the Portal Setup dialog window. Select the row by clicking it and choose Delete Record from the Mode menu. The dialog will read, 'Permanently delete this one related record?' Clicking Delete will delete only that related record. I have allowed deletion of portal records, and when I select a row and hit Delete it says "Permanently delete this one related record?" and when I click Delete, it deletes the entire record, not the portal record. I have another database that has a portal in it and the deletion of portal records works fine. I even tried to copy and paste that portal into the problem database and it still deletes the whole record. How can I fix this? Thank you. --Sue

I have a database that I am trying to produce a report from. I have a report form set up with subsummaries to sort the data. What I am trying to do is to get counts of the number of records in the subsummary as a whole, then just display a subset of these records. For instance, count the number of all red shirts, blue shirts, and green shirts as subtotals, and have these numbers print on the report as a subsummary header. Then display individual shirt data for the set of red shirts that are short-sleeved only, then for the set of green short-sleeved shirts, etc. The total number of individual records will be less than the totals displayed in the subsummary, because I am omitting long-sleeved shirts. I can get the subset of records to print correctly, but once I start omitting records for the report, I cannot have it retain the subsummary header information: "Red shirts, 10 total, 0 short sleeved, 14 long-sleeved" is kind of what I am looking for. This gives a report of the total shirt inventory but only displays the individual records of the found set. I hope this makes sense. If anyone has ideas for me I'd appreciate it! --Sue