Hey Everyone,
I need to write a chunk of code that compares two tables. These were tables pulled from a database so the table rows are indentifiable by a primary key that may or may not be a concatination (sp?) of a few columns. Lets say we have table A and B. Now all of table B is actually in table A. What I need to do is Search through table B record by record and find its cooresponding record in table A. By cooresponding record I mean the record that has the same primary key, which again can be more than one column. Now I could do a simple V lookup, however I don't think this will work because like I said I need to compare multiple columns. Any help would be appreciated. Thanks!
I need to write a chunk of code that compares two tables. These were tables pulled from a database so the table rows are indentifiable by a primary key that may or may not be a concatination (sp?) of a few columns. Lets say we have table A and B. Now all of table B is actually in table A. What I need to do is Search through table B record by record and find its cooresponding record in table A. By cooresponding record I mean the record that has the same primary key, which again can be more than one column. Now I could do a simple V lookup, however I don't think this will work because like I said I need to compare multiple columns. Any help would be appreciated. Thanks!
