I am done with work for the summer in 2 days and my bosses would like me to figure this out for them ASAP. Here's the rundown:
I have a table called tblEntity with the following fields:
Another table called tblReviews with:
- EntityID: primary key, Autonumber
- EntityName: Text
And another table called tblNotes with:
- ReviewID: primary key, Autonumber
- EntityID: Number
- ReviewDate: Date/Time
- Review: Memo
The EntityID Number fields in my Reviews and Notes tables are linked to the primary key EntityID in my Entity Table. (enforced with referential integrity). This is so I can have multiple reviews and notes for the same EntityName.
- NoteID: primary key, Autonumber
- EntityID: Number
- NoteDate: Date/Time
- Note: Memo
Basically the tblReviews and the tblNotes are the exact same thing except "Notes" and "Reviews" are used for different things in the company I work for. I have created a Report with: EntityName, ReviewDate, Review, NoteDate, and Note.
The problem is that when I write a "Review" for a company but don't write a "Note", the review doesn't show up at all, and vice versa. The company only shows up in the report if there is both a "Review" AND a "Note" written about it. I want the Entity to show up if EITHER a review or note has been written about it, not just BOTH.
Does anybody know how to solve this? Thanks a lot.
-Luke