Filtering Records for Labels

[Benjer]

Hello,

I would like to print mailing labels for a simple table that includes addresses. However, some records should receive the mailing and some should not. I have created a field with a yes/no radio button that lets me know whether someone should receive the mailing or not. How do I create a new label layout that only prints labels for records with "yes" in that field?

Thanks,

Benjer

[Lee Smith]

It sounds like you have a layout for printing, if not let me know.

If so, just do "Find" for the "Yes".

Once you have a found set, you should be able to print what you want.

HTH

Lee

[Jeff Albro]

Is there a way to restrict a layout to a (pre) found set? So if I have a "faculty" layout it only shows faculty when faculty, staff, and students are combined in one table?

Actually, thinking about it, would I create a global table with a faculty global field, and then set the layout to view that table and related records in the people table?

-Jeff

[dreamingmind]

Jeff,

That would work. You could make it a little more flexible if you used a script that set the global to some value and showed you the related records. Then the same tool could work for faculty, students or whatever other grouping you chose to define.

A series of buttons that call the script and pass in a script parameter will allow you to handle everything with your one layout and one script.

Regards,

Don