Incident Report Database Design

I asked this question a couple of weeks ago but the suggested answer didn't
meet the need. I am a newbie at Database design and any help would be much
appreciated

I am developing an Incident Report Tracking Database and I need to be able
to enter one or several items from a list in a specific record.

This challenge is very similar to developing a record for sales transations.
I sales record could have one item from inventory or it may have several
items purchased from inventory in a single order.

How do I set up a table to accept more than one item from a list in a field?

In my application an incident report could involve just one employee or it
could involved several employees. I need to be able to list one or as many
as were involved in that incident in the record for that incident.

Again Example: an order may have one item, or an order may have several
items.

Jon, I did not see the answer you received previously, but you must use two
tables for this:
- one for the incident (with an IncidentID primary key);
- a related table for the people in the incident (with an IncidentID foreign
key).

Open the Northwind sample database.
Open the Relationships window (Tools | Relationships).
See how the Orders and Order Details tables fit together.

You must not store muliple people in one field of the main table, and you
must not create fields called Person1, Person2, etc. The related table is
the only normalized solution.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jon Davidson" wrote in message
...
I asked this question a couple of weeks ago but the suggested answer didn't
meet the need. I am a newbie at Database design and any help would be
much
appreciated

I am developing an Incident Report Tracking Database and I need to be able
to enter one or several items from a list in a specific record.

This challenge is very similar to developing a record for sales
transations.
I sales record could have one item from inventory or it may have several
items purchased from inventory in a single order.

How do I set up a table to accept more than one item from a list in a
field?

In my application an incident report could involve just one employee or it
could involved several employees. I need to be able to list one or as
many
as were involved in that incident in the record for that incident.

Again Example: an order may have one item, or an order may have several
items.

Thank you so much, your advice was very helpful

"Allen Browne" wrote:

Jon, I did not see the answer you received previously, but you must use two
tables for this:
- one for the incident (with an IncidentID primary key);
- a related table for the people in the incident (with an IncidentID foreign
key).

Open the Northwind sample database.
Open the Relationships window (Tools | Relationships).
See how the Orders and Order Details tables fit together.

You must not store muliple people in one field of the main table, and you
must not create fields called Person1, Person2, etc. The related table is
the only normalized solution.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jon Davidson" wrote in message
...
I asked this question a couple of weeks ago but the suggested answer didn't
meet the need. I am a newbie at Database design and any help would be
much
appreciated

I am developing an Incident Report Tracking Database and I need to be able
to enter one or several items from a list in a specific record.

This challenge is very similar to developing a record for sales
transations.
I sales record could have one item from inventory or it may have several
items purchased from inventory in a single order.

How do I set up a table to accept more than one item from a list in a
field?

In my application an incident report could involve just one employee or it
could involved several employees. I need to be able to list one or as
many
as were involved in that incident in the record for that incident.

Again Example: an order may have one item, or an order may have several
items.