Categorize Reports

  • Thread starter Thread starter SylvieB
  • Start date Start date
S

SylvieB

Hi All
does anyone know how to categorize a bunch of reports by Subject?
So far, I have created a form, created a list box that display 3 categories
for example Brian's reports, Keith's reports, Mike's reports. When a user
makes a selection, he would pick a report from a combo box associated with
that category, let's say Brian's reports.
I'm having a hard time to do that. Does anyone know how to do that? I would
greatly appreciate any help. thanks a lot.
Sylvie
 
I generally create a couple application tables for this:

ztblReports
===============
rptRptID autonumber primary key
rptRCaID link to ztblReportCategories.rcaRCaID
rptName actual name of the report object like rptTimeSheet
rptTitle friendly name to display
rptStatus active, inprogress, inactive
rptAuthor etc

ztblReportCategories
=================
rcaRCaID autonumber primary key
rcaTitle friendly name to display

If a report can be in two categories, remove rptRCaID from ztblReports and
create a junction table.
 
Back
Top