Compare two lists and remove those that match. How do I do this?
Hi, I am an advanced beginner on FMP for Mac.
I have a list of e-mail addresses, about 10,000.
We can call this list A.
Then I will be getting a list of those e-mails that unsubscribed.
We can call this list B.
I will want to remove all of the e-mails that show up in list B, that
I can find in List A so we don't mail them again.
There are e-mails in List B, that will not be found anywhere in list A.
How can I do this as simply as possible in FMP for Mac.
There will be too many of these to go through manually, so it will need some type of automatic function.
Thank you soooo much!