I have two tables:
BUYERS
ItemNumber
UserID
TransactionDate
Timeliness
Compliance
Reasonableness
Communication
FeedbackLeft
Notes
SELLERS
ItemNumber
UserID
TransactionDate
Timeliness
Shipping
Quality
Communication
Professionalism
Notes
As you can see, ItemNumber, UserID, and TransactionDate are common in both tables. The other fields are the only things that differentiate the two tables.
The problem here is I want to construct a query and eventual report from that query that treats the results as one "virtual table". In other words, I want one column for ItemNumber instead of two seperate ones (since it is present in two seperate tables). The same for UserID. Right now I cannot do that.
Is there a way I can make the two tables "overlap" for purposes of this report? Or should I re-design the table into one big table and combine all fields? Any advice would be appreciated.