I have two tables that hold different info for a common record(drawing number). The one table holds revision data(A,B,C, etc.) The second table holds records of any revisions being canceled(someone changed their mind after staring a revision). I need one report that will give me an outline of activity for any particular drawing.