I am working with a non-profit art association, and am a beginner with FM. A previous DB person set up a membership data base for them, which uses multiple tables. One of the tables is called "memberships" and it contains multiple records; 1 for each year of membership. The club wants to be able to generate mailing labels which include the membership year. I can make the change but invariably the year selected is the year is associated with the first record. Given that limited information, is there a method of making certain the most recent date is selected? I have sorted the table but it seems to revert to default order when I print mailing labels and the first date continues to be selected.