If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Categorize Reports
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 |
#2
|
|||
|
|||
Categorize Reports
Sounds like you want a Switchboard.
"SylvieB" wrote: 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 |
#3
|
|||
|
|||
Categorize Reports
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. -- Duane Hookom Microsoft Access MVP "SylvieB" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|