Categorize Reports

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top