tables and subtables

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
 

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