Creating a Table for Information that is Pending

[iheartvba]

Hi Guys,
This is not a programming question, but there is an alarm ringing in the back of my mind telling me that there is something missing with this table/application I have made.

There is a table to record the documents/information that are still outstading for a client, which are the reason their tax return has not yet been completed i.e. it is Pending Information so i will refer to the table as tblPendings. tblPendings includes fields for JobID, The Category the Pending Falls into (e.g. bank interest) and additional notes describing the document. There is a UserStamp and DateStamp but you can leave those out of the picture.

I am just wanting to know whether any of you have created such a table or similar application to record a pending and then also transact in the database when that pending information has been received (I am currenlty transacting the receipt by using an append query which creates a contra-record in another table) and what features or fields have you found to be usefull in your experience.

I thank you in advance as the advice I receive here has always been invaluable in my learning.

[missinglinq]

My approach, rather than having a separate "pending" table, would be to have checkboxes in the main table to indicate missinging items. You could base queries/reports off of these checkboxes, and when the items are provided simply uncheck the appropriate boxes.

Linq ;0)>

[iheartvba]

Thanks Missingling,
The reason I have the table corresponding to the pendings table is because it could be another consultant that collects the document for the person who actually needs the document. So when the consultant who created the pending comes to the office they can look at the database and see
1.who has collected their document (Auto UserID Stamp)
2. The Data it was collected (Auto Date Stamp)
2. any additional notes
3. Where they have placed the document

I am thinking that is a bit of overkill though I am starting to again lean in the direction you've suggested .