Report

[surlyb]

I work for a small, regional real estate paper as the webmaster. I have a database (FileMaker Pro 4, but I have just purchased FielMaker Pro 5.5) set up with the following fields, date in, realtor, company, realtor name first, realtor name last, realtor email, realtor URL, realtor phone1, realtor phone2, comp (a shortened name for the company), company street address, company city/sate/zip, property address, tag line, area (N, S, E W), price, property URL, Status (active/inactive/pending) and notes. Each property has it

[danjacoby]

Create a columnar list layout with a (leading) sub-summary part when sorted by realtor. Put the realtor's name field in the sub-summary part, and whatever fields you need to see on the report in the body part below it.

Now, after the find, do a sort by realtor name (yeah, I know, there's only one, but you gotta do it anyway), and you can print the report.

Even better -- you can print reports for as many realtors as you want at the same time. Just have the sub-summary part "Page break before each occurrence," and each realtor's list will start on a new page.

[andygaunt]

Ok.

If you create a columnar list report, and place the realtor, property details and the email in the report and then categorize by realtor , at the end when it asks if you want to make a script say YES.

This is so it remembers to sort by realtor.

once you have finished, you will see a subsummary part with the realtor name in. in the body will be the property details.

When you preview this report and it is sorted by realtor all their properties are listed. Then it goes on to the next realtor.

As for emailing this, that is a bit more tricky as the report only looks like this when sorted.

It would have been better to have a realtor database and a property database. Then you could have just shown the related records and created a script to concatenate the properties into the body of the email.

HTH