josephbupe
Registered User.
- Local time
- Today, 16:58
- Joined
- Jan 31, 2008
- Messages
- 247
I am trying to help my office in tracking cases recorded on individual files.
1. tblFiles (FileID=PK)
2. tblCase (FileID=FK)
3. tblCase_Notes
Any one File can have many Cases on it; and one Case can have as many notes as possible.
In the table "tblCases" I have included a field to store status of the case (Open/Closed).
On the main form "frmFiles" is a listbox of the Files stored in the table "tblFiles" and I can open the details form of any given file by double-click in the listbox. Now in the same listbox I want to include a field "Open Cases" to show a total count of all cases on a particular File with the status "Open". This should be obviously DCount Function but never used it before.
The actual records to count are in the table "tblCases" and I intend to have counts stored in "tblFiles" so that the counts will show in the listbox.
I will appreciate your help.
Joseph
1. tblFiles (FileID=PK)
2. tblCase (FileID=FK)
3. tblCase_Notes
Any one File can have many Cases on it; and one Case can have as many notes as possible.
In the table "tblCases" I have included a field to store status of the case (Open/Closed).
On the main form "frmFiles" is a listbox of the Files stored in the table "tblFiles" and I can open the details form of any given file by double-click in the listbox. Now in the same listbox I want to include a field "Open Cases" to show a total count of all cases on a particular File with the status "Open". This should be obviously DCount Function but never used it before.
The actual records to count are in the table "tblCases" and I intend to have counts stored in "tblFiles" so that the counts will show in the listbox.
I will appreciate your help.
Joseph