Hey everyone, got an interesting one and just looking to be pointed in the right direction:
I have 2 tables in my database: "current clients" and "clients that canceled". Each company has a unique company ID that is used in both tables. What my goal is is to write something that will take all of the company ID's from clients that canceled and then search the "current clients" table and delete all companies with matching ID's.
I am coming from a world of mySQL and php, but unfortunately my company now requires Sharepoint and Office products to be used exclusively. I was figuring I could run a loop that takes each canceled company ID line by line and checks the other table to see if it exists. If it finds a result, then I would want it to delete that entire row of data.
That's the goal. Anyone have a direction they can point me in? Is this something best suited for a customized macro?
Thanks in advance!