I'm working on a fairly complex database. I need to find all persons that have attended conferences to extract their address data for mailouts. The issue is that in the People file I search via a related field drop down, value 'conference attendee' (relationship from the Delegates file) and the results displayed and what is exported are not accurate.

 

The database contains 30K records, it returns 14K attendees on the search, but about 300 of these are not attendees but some other item on the dropdown.

 

Then when I export the data, it exports 19K records. The extra 5K records are blanks!

 

Any idea what is going on here?

In FileMaker, perspective is everything.  We would need to understand your relationship model, the layout you are on when you export, and your specific search criteria.  It is best to zip and attach your file.  :-)

Oh OK. Its a complex multi-file database and I can't clone it as its locked. I think I'll leave it as I'll clean it up in an interchange file. I was just curious as to what was going on.

Can't clone it because it's locked. Not sure what that means. Enlighten me?

do the other items from the dropdown contain some of the parts of the search criteria? afai understand you're looking for "conference" and " " and "attendee".

 

if you want to find the "conference attendee" only create at least a field w/o the dropdown and enter "==conference attendee" (w/o the quotaion marks) via a e.g. script.

 

hth

pixi

I suggest that you run the search for conference attendee on the Delegates Table (using search criteria as suggested by @pixi), then do a GTRR step based on all the found records to the People table. 

 

When you do the export make sure that it is done with respect to the People table, not to the layout you are on when exporting, which i suspect contains a portal into the delegates file.

 

HTH

 

Brian