Jump to content

How create single list from multiple records?


This topic is 6102 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

[color:black]I'm new to filemaker. I'm trying to create a report that vertically lists all the NAMES taken from multiple records based on which item or items have been selected in a checkbox.

On my main account page I have a checkbox field with 5 values. Each record could have 0 to all 5 values checked, but each record will be different variations throughout the table.

I want to have one single report page for each of the 5 items that lists all the NAMES from all the records that have that item checked.

I know that the checkbox values are divided by carriage returns. I've tried to use GetValue and FilterValues in various ways with no luck.

I was thinking that I could make a script that would Find all records with a particular item having been checked and then copy all the NAMES fields in all the found records and paste them to a single report page field, but I can only get it to paste them all on invidual report pages.

Overall... I'm sure there are a number of solutions to this problem, so I'm open to all suggestions. I've spent a day and a half reading posts and trying to learn more about the program, but i can't seem to find the answer. Hope someone out there can help. Thanks.

I'd also be happy if someone could tell me how to make a basic columnar report with 2 columns for a single 8.5 x 11 page. I thought about using labels, but I need to have a header.

Edited by Guest
Link to comment
Share on other sites

Welcome mondiglee,

One way you could do it with your current structure is to run and print a report for each value. You'd have a script Find records for the first value and print that, then do the same for each successive value. You could do this with a loop, or hard-code the Find criteria. You'd end up with separate pages for each value.

For something more flexible, where the report is all together (grouped by value), you'd need to change that checkbox set into a portal of selected values. Then run the report from a layout based on the related Selected Values table. You could use a sub-summary report (with a Sub-Summary by Value) part to show sub-totals by Value field.

Link to comment
Share on other sites

This topic is 6102 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.