Multi-value fields and sub-datasheet.

[specialk]

Let me preface to say that I'm new to Access.



I am creating a database for tracking projects/assignments - where multiple people can be assigned to one project. I created a multi-value field called "Assigned To" which is looking up the data from a table listing personnel.

The problem is unlike my other tables, where there are sub-datasheet is created once the relationship between the tables is established; the personnel table does not have a sub-datasheet.

Is there anyway around the issue I'm having? Can I:
1. Create a sub-datasheet so I can see all the projects a person is assigned to. OR
2. How do I go about creating fields that address one project to many people.

Thanks.

[June7]

The issue is the multi-value field - I never use them. Review http://office.microsoft.com/en-us/ac...001233722.aspx

Instead of multi-value field, create a 'junction' table to associate personnel with projects/assignments.

Use forms and reports to enter/edit/output data.