The key is in how you structure your data. From what you post, you need these tables/relationships:
Presentors::PresentorID = Eventa::PresentorID
Names and addresses for presentors would be entered a single time in the presentors table but can be linked by PresentorID to any number of event records. You'd print your address labels from a layout based on Presentors and that way would avoid the existance of any duplicate address labels.
From your current setup, you may be able to fix this temporarily with a script, but if you are entering the presentor info over and over again into each event record, there is no way to be sure the data for a given presentor was entered exactly the same way each time. The addition of a single extra space character in a name could defeat the folllowing script:
#First perform a find to pull up the event records you want
Sort [restore ; no dialog ] (Sort by all presentor name fields so that events for each presentor are grouped together)
Go To Record/request/page [first]
Set Variable [$PresentorName ; YourTable::FirstName & YourTable::LastName //adjust this calc to use all of your name fields here]
Go To Record/Request/Page [next ]
If [$PresentorName = YourTable::FirstName & YourTable::LastName ]
If [Get (RecordNumber ) = Get ( Found Count ) //last record ]
Exit Loop If [True]
Set Variable [$PresentorName ; YourTable::FirstName & YourTable::LastName ]
Go To Record/Request/Page [next ; exit after last]
thanks for the response. Unfortunatelly this is a temp contract and I don't have time to rewrite the database in its entirety. Maybe they should have made this a request on day one lol. Oh well, I guess this is what they get for not being up front and clear at the beginning.
thanks again for the help/suggestion :)