Jump to content
Sign in to follow this  
GMRMS

Mailing labels

Recommended Posts

Perhaps this is in the wrong area of the forum, and if so, feel free to move it.

I am working (volunteer basis) with a small art association that uses FM for tracking membership. In the past a contractor created a FM database, with multiple tables, for their use. The "memberships" table stores history so there can be more than one record per member. The club would like to place the membership year on mailing labels but invariably the first (oldest) record is selected. Is there a "ready made" way to tell FM to output the date from the last (i.e. most recent) record? I have sorted the memberships file but that had no effect.

Share this post


Link to post
Share on other sites

Hi GMRMS, and welcome to the Forum.

Automatic message

This topic has been moved from "FileMaker ClassifiedsSolutions Wanted" to "Database Schema & Business LogicRelationships".

I moved your topic from Solutions Wanted, because that topic is reserved for asking assistance in finding a ready made solution

Searching for that ready made solution, perhaps someone else can point you in the right direction

I believe that you are really just wanting assistance with your file.

Lee

Share this post


Link to post
Share on other sites

The "memberships" table stores history so there can be more than one record per member.

Perhaps you could print from the Members table - with a calculation field returning the Max() of memberships year?

Alternatively, sort the memberships by Member and by Year, descending (or ascending) and print from a layout that contains only a leading (or trailing) sub-summary by Member part and no body part.

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.