Categorize Reports

[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

 

[KARL DEWEY]

Sounds like you want a Switchboard.

 

[Duane Hookom]

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.