Jump to content

Multiple modifcations to find

This topic is 6526 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This find will probably be obvious but....

I have a popuplist that list various cities. The user selects the city out of the list. All of the contacts for that city then show up. All is well..

The user then selects what they wish to do with this list... one of which is "send a letter".

When the user selects this option I have a script to run that will find duplicates based on the found set (the city selected). So far this has not been a problem. (I followed the threads here for marking duplicates as "0" and the unique record with "1")... now here is the problem...

It will find the duplicates within this city and show them on screen. But then I am having a problem making the script omit the duplicates and leave me with just the unique records from the city that was selected.

If I do this to all records at the same time it is fine. The script will remove the duplicates and add the word last name and "family "...

what am I doing wrong

Version: v6.x

Platform: Mac OS X Jaguar

Link to comment
Share on other sites

If you're using portals & relationships to display these records, what's needed is a multiple-key relationship that will also include the marked duplicate field with the city. FM7 makes this trivial. There are several techniques to do this, a common one is to make a calculation field with: cityField & NumToText(markedField). In the main file the calc would be cityField & "1".

If you're using search to find these records, search for the city and markedField set to 1.

Did this jog your brain into gear?

Link to comment
Share on other sites

This topic is 6526 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.