Need help please! Database broken.

[FaciaBrut]

We rebuilt this database (magazine.fp7) after updating to Filemaker Pro 7 from version 5. The database is used to compile MLS real estate listings for publication in our monthly real estate magazine. The file magazine.fp7 gets data from the other two files, directory.fp7 and magazine sections.fp7. Now the last two fields in the export field of the Ad Copy layout are not populating (Ad Name and Ad Phone). Can anyone take a look at this and help me to straighten this out? The files (with one dummy record)can be seen at Welcome Home magazine . Thanks in advance.

[gdurniak]

Since Ad Name and Ad Phone are related fields, the "Agent" name has to match exactly between files. Be sure to strip out (trim) any trailing spaces, in both files

It does appear to work in your sample file

[FaciaBrut]

Thanks for the quick response! What I can't get to work is the very end of the display of the Export field in the Ad Copy layout. Notice that there are two blank spaces, separated by commas, where the Ad Name and Ad Phone should be. I think there is something wrong with the calculation. The "Ad Name" is not the same as the agent's full name, but is what is to be printed in the magazine under his ad listing.

[kevh72]

In your export field calculation, you have a "GetField" function for Ad Name and Ad Phone. This isn't necessary if you just want the content of the field to display. Attached is your file, modified.

By the way, your files do not appear to be that complex; therefore, I would recommend rewriting your database from scratch using FMP7's new relationship model. You may catch other changes that resulted from converting to FMP7.

magazine.zip

[FaciaBrut]

Thanks so much!!!... that was too simple! (Yeah, we are magazine layout people, not database people!) Second question... In the layout named "Page Layout", we still can't get the Our Area Name field to populate.

[kevh72]

It currently doesn't populate because there's no lookup or calculation for that field based on any relationship.