Would it be possible to create a filter that would show all the records in Table A that are also in Table B? Both tables have the same primary key, but the other fields are different. Thanks!
are the two tables related? if so, how? if they are "properly" related, put them both in the query designer, select the fields you want and you're done.