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

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

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
Sign in to follow this  

×

Important Information

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