Jump to content
Sign in to follow this  
LivingRoutes

Creating a list of names...

Recommended Posts

I'm pretty new to FileMaker, so I'm hoping this isn't a hard question to answer (I just don't know how to do this..)

I'm trying to create a report and I want to list all of the people who have not paid for a program which they've registered for. I have a 'People' table which stores their names (among other things), a 'Registration' table which relates a person to a program and tracks if they've paid, and a 'Program' table that has information about the program. I'm not sure if I should use a portal here or what (I don't know how to show a subset of a found set...) so please help!

Thanks.

-James

Share this post


Link to post
Share on other sites

You can create a report reflecting your Registration table. Find all the records that are not paid, and then you can generate a report based of those records. You can put the related Person's name and related Program name fields on the report layout to display the actual names rather than the key field values.

Share this post


Link to post
Share on other sites

Thanks for responding so quickly..

Would this work if I have a number of programs and want to see this information for each one all on one page?

Share this post


Link to post
Share on other sites

For both this thread and your other thread a summary report can be used.

Here is a recent example.

Summary Report with Count

Share this post


Link to post
Share on other sites

Duplicate Deleted.

Share this post


Link to post
Share on other sites

Mr. Vodka, Thanks for your two posts.. It took me a while to see how they would solve the question I asked here (although your second post answered my other question perfectly); and sorry about the double posting -- I didn't realize these questions had the same answer

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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