How do I store multiple items from a list in a record

[Jon Davidson]

I am very much a newbie when it comes to Acess and need help with developing an Incident Report tracking Database.

I need to develop a system that allows me to choose one or many items from one table and place them in a specific field on another table. Specifically, I need to be able to select from the employee table one or several employees who were involved in a specific incident. I then need to be able to filter and/or sort the incident records by employees envolved.

The closest parallel I can think of would be an order database that will allow you to select one or several items from another table to go on a specific order.

Any help would be greatly appreciated!

Thanks

 

[Van T. Dinh]

Firstly, Field values should be atomic, meaning each Field value should
store ony one item of data, NOT a list of items which I think you try to do.

It seems that you need a Many-to-Many relationship between Employees and
Incidents to store the data correctly / effciently. Check Access Help, your
Access books or Relational Database Design Theory book on Many-to-Many
relationship.
--
HTH
Van T. Dinh
MVP (Access)

I am very much a newbie when it comes to Acess and need help with

developing an Incident Report tracking Database.

I need to develop a system that allows me to choose one or many items from

one table and place them in a specific field on another table.
Specifically, I need to be able to select from the employee table one or
several employees who were involved in a specific incident. I then need to
be able to filter and/or sort the incident records by employees envolved.

The closest parallel I can think of would be an order database that will

allow you to select one or several items from another table to go on a
specific order.