Combo Box or something else?

[Guest]

I’m needing to set up a suicide db (attempts/completions) and I need to track
psychosocial stressors (e.g., financial, vocational, relational, etc.). That
being said, I originally set up a single combo box…where the user could
select from the combo list. However, I’ve been informed that the db needs to
permit for the recording of multiple stressors…Reason: rarely is only one
stressor reported. How would I set this up? Would I simple replicate the
combo box (x 3) and that would permit users to select multiple stressors? Or
something else? I need to be able to query the following type questions:
how many people reported 1 particular stressor or 2 particular stressors or
any combination of stressors?

Any help would be appreciated…

Thank you… steve

 

[Douglas J. Steele]

Since the relationship between attempts and stressors is many-to-many (one
attempt could have been triggered by multiple stressors, one stressors can
be linked to multiple attempts), you need to introduce an intersection table
to resolve that many-to-many relationship. The intersection table would
include the primary key from the Attempts table and the primary key from the
Stressors table, with the combination of those fields making up the primary
key for this new table.

What's typically done is to use a form/sub-form set up to handle this. Take
a look in the Northwind database that came with your version of Access. This
is analogous to the relationship between Orders and Products (which is why
the Order Details table was introduced). From a user interface perspective,
see the Orders and Orders Subform forms.

 

[Bob M via AccessMonster.com]

I would venture that it is one-to-many attempts to stressors as an attempt is
a unique event. One person may have many attempts but each is different.
You can then use a form based on the main table with a PK and a subform based
on another table of stressors with a FK linked to the PK of the main. The
subform should be continuous and each time you select a stressor from the
combobox a new record would popup so all you would have to do is select the
combo again in the new record.

Since the relationship between attempts and stressors is many-to-many (one
attempt could have been triggered by multiple stressors, one stressors can
be linked to multiple attempts), you need to introduce an intersection table
to resolve that many-to-many relationship. The intersection table would
include the primary key from the Attempts table and the primary key from the
Stressors table, with the combination of those fields making up the primary
key for this new table.

What's typically done is to use a form/sub-form set up to handle this. Take
a look in the Northwind database that came with your version of Access. This
is analogous to the relationship between Orders and Products (which is why
the Order Details table was introduced). From a user interface perspective,
see the Orders and Orders Subform forms.

I'm needing to set up a suicide db (attempts/completions) and I need to
track

[quoted text clipped - 15 lines]

Thank you. steve

 

[Guest]

Thank you...

I would venture that it is one-to-many attempts to stressors as an attempt is
a unique event. One person may have many attempts but each is different.
You can then use a form based on the main table with a PK and a subform based
on another table of stressors with a FK linked to the PK of the main. The
subform should be continuous and each time you select a stressor from the
combobox a new record would popup so all you would have to do is select the
combo again in the new record.

Since the relationship between attempts and stressors is many-to-many (one
attempt could have been triggered by multiple stressors, one stressors can
be linked to multiple attempts), you need to introduce an intersection table
to resolve that many-to-many relationship. The intersection table would
include the primary key from the Attempts table and the primary key from the
Stressors table, with the combination of those fields making up the primary
key for this new table.

What's typically done is to use a form/sub-form set up to handle this. Take
a look in the Northwind database that came with your version of Access. This
is analogous to the relationship between Orders and Products (which is why
the Order Details table was introduced). From a user interface perspective,
see the Orders and Orders Subform forms.

I'm needing to set up a suicide db (attempts/completions) and I need to
track

[quoted text clipped - 15 lines]

Thank you. steve

 

[Guest]

Thank you...

Since the relationship between attempts and stressors is many-to-many (one
attempt could have been triggered by multiple stressors, one stressors can
be linked to multiple attempts), you need to introduce an intersection table
to resolve that many-to-many relationship. The intersection table would
include the primary key from the Attempts table and the primary key from the
Stressors table, with the combination of those fields making up the primary
key for this new table.

What's typically done is to use a form/sub-form set up to handle this. Take
a look in the Northwind database that came with your version of Access. This
is analogous to the relationship between Orders and Products (which is why
the Order Details table was introduced). From a user interface perspective,
see the Orders and Orders Subform forms.