Hi there

All the issues and actions are tied to a category.

An Issue can have more than 1 action. For instance, if a student has no role
model in his family, then a possible action is to develop a positive role
model, [Category: Family, Issue: Lack of Role Model; Action: Develop Adult
role models]

Several issues may have the same action. For instance, a youth has no adult
role models and has a poor relationship with his family, then the action is
to develop a positive role model. [Category: Family, Family. Issue: Lack of
Role Model, Action: Develop adult role model]

Does this make sense?

Thanks





"Dorian" wrote:

Is it possible to merge the Actions and Issues tables together or is it best
to leave them separate?
Not if an issue can have more than one action.
Also you have issues and actions both linked to category, what is the
purpose of category? Might you not have different subsets of categories for
issues and actions?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"forest8" wrote:

Hi

This is a follow to a previous question concerning relationships in a table.

These are my tables I have in my database.

Students
StudentsID
LastName
FirstName
HomeroomTeacher
(ohter info relating to the student)

Cases
CaseNo_ID PK
StudentID FK

Categories
CategoryID PK
Category (e.g. School, Community, Individual, Peers, Family)

Issues
IssuesID PK
Issues (text, e.g. lack of role models)
CategoryID FK

StudentIssues
CaseNoID link to Cases Table
IssuesID Link to issues Table

Actions
ActionsID PK
Actions (text, eg. New Adult Role Models)
CategoryID FK

StudentActions
CaseNoID link to Cases Table
ActionsID link to Actions Table

Does this look right to anyone?

Is it possible to merge the Actions and Issues tables together or is it best
to leave them separate?

Thank you in advance for your help