Re: Is this possible in FilemakerPro 7 ? ...

I understand you to be saying that if there are record pairs between
the two files then you want to get rid of both these records.
The easiest way to do this is to create a calculation field "One" in
each file which simply equals 1.
Next create the field "Mark For Deletion" in each file.
Create a link (relationship) between the 2 files so that
File1::Field1 = File2::Field1
File1::Field2 = File2::Field2
File1::Field3 = File2::Field3

In a layout in File1, place the field "One" from file 2 using the above
mentioned relationship.
Do a search for the number 1 in that field; only duplicate records will
be found because the related record must exist in order for the field
to contain a 1.
Here's the catch, DON'T delete the records, mark the flag for deletion
but before you do, repeat the same procedure in the other file.

.

Relevant Pages

  • Re: Macro to Remove text between two characters.
    ... Why are you marking for deletion and not deleting immediately? ... Is the bigger question really, "What is the best way to mark text for ... But there are other ways to mark text that may be less confusing to search ... character) until it reaches another character, ...
    (microsoft.public.word.vba.general)
  • Re: Help, ntlers
    ... So it's just a right click, choose mark all for deletion and let MailWasher get on with it:( ... At least I don't have to mark each one for deletion separately. ... I used to eat a lot of natural foods until I learned that most people ...
    (uk.people.silversurfers)
  • Re: Proper way to write a conditional statement with ands
    ... Delete/replace any sensitive data. ... Mark the rows that meet your deletion ... criteria. ...
    (microsoft.public.excel.programming)
  • Re: SE W800I delete emails
    ... If I don't want an email I just mark it for deletion (apart from wasted ... the POP3 server. ... my phone but still be available for download to a laptop pop3 client... ...
    (uk.telecom.mobile)