I was hoping that someone on here could help me with something. I have two databases, one very large and another which is small compared to the other one. I will call the large one "A" and the other "B".
What I need to do is compare records from B against A and either flag the record in A or pull the record into another database which I will call "C". I was hoping to compare 2-3 fields and if they matched I want the record to be placed in C (or flagged in A).
Any suggestions on how to pull this off?
