I have a table of "memos". each record in that table has a primary
key "memo ID" that is autonumber. I have another table that is "memo
receipts" with each record having a "receipt id" field that is not a
primary key. When a user reads a memo, I create a receipt record that
shows that they have read and acknowledged the memo. "receipt id" is
set equal to "memo id". I have this part working fine. Next what I
want is when a user checks for new memos, I want to display only those
memos that dont have a receipt record for that user. Any memos that
have a receipt record for the current user have already been read and
acknowledged by that user. I can display the memo records very well
using a Memo form with a receipt subform. This is great but I need to
be able to only show memos that have not already been acknowledged by
the current user.
Please help