J
Judy
I need a way to file the steps to autonomy clients take in
a table to be able to pull up for reporting purposes.
The list of steps is broken into categories then sub
categories:
Ex: Employment:
Resume
Training
Job Search
Interviews
Gainful Employment
Medical Benefits:
Needs assessment
Application
Coverage
(etc.)
I'm trying to think how to track this data--I have a table
currently set up for Clients info with a 'steps' field,
and the original list was another table to be used as a
drop down menu on forms.
This way, it looks like I'll need a table for the main
categories, then another table for each set of options in
that category, which then will be a 'stepdetail' field on
teh main client info table.
Is there an easier way to do this without all these little
tables for drop down menus? And then how do I tie all
these into combo boxes for a form?
--Judy
a table to be able to pull up for reporting purposes.
The list of steps is broken into categories then sub
categories:
Ex: Employment:
Resume
Training
Job Search
Interviews
Gainful Employment
Medical Benefits:
Needs assessment
Application
Coverage
(etc.)
I'm trying to think how to track this data--I have a table
currently set up for Clients info with a 'steps' field,
and the original list was another table to be used as a
drop down menu on forms.
This way, it looks like I'll need a table for the main
categories, then another table for each set of options in
that category, which then will be a 'stepdetail' field on
teh main client info table.
Is there an easier way to do this without all these little
tables for drop down menus? And then how do I tie all
these into combo boxes for a form?
--Judy