I am new to filemaker pro and have found it extremely easy to use for the most part. But I have not been able to find out how to perform a nth select on a found set of data. For example, for a marketing campaign all individuals with the title of V. P. Marketing are selected in the Midwest. This represents a count say of 350 companies and 750 individuals. The marketing department has decided to save on the sale of postage by only mailing to one individual per company. I can export the found set into Excel and perform the one per company function in Excel, but would like to not have to take that extra step every time the marketing department requests one per company for a mailing campaign. Any suggestions how I can achieve this in Filemaker Pro.
If it is helpful, the database structure is fairly straightforward with a company database and a contact database related to one another by a company key number field.
Thanks for any help.