Database Fields

[specialk]

Hello,

I’m running into an issuewhere I’m creating an Assignment database and the unique thingabout this database is that, more than one person is usually assigned. When I initially created the database, I created my employees table and then created Employee1 and Employee2 fields to account for the multiple people assigned. I created the relationships between the table and the fields. However now, I’m now running into theissue where Employees Table and try toexpand to see the dependencies/relationships but there’s no information. Isuspect it’s because the table and field name is different. I know accessallows multiple entries in one field, however I wanted to be able to runreports for each employee and I’m not sure if a field with multiple entriescould facilitate this. I'm using this database to see how many case assignments one employee has.

Can anyone offer any insight as to how to best design this database field and tables to capture when more than one person in the same employment category is assigned to the same case/project?

Thanks

[pbaldy]

The Employee1 and Employee2 fields are not normalized, as you're running into. The normalized design would be a separate table for employees assigned to each project. In essence it's a many-to-many junction table. A project can have many employees, an employee can be on many projects.

[specialk]

I created a multi-value field to address the issue. However, now when I go to the employee table, there's no sub-datasheet.

[pbaldy]

Sorry, I don't like and haven't used the new multi-value field. I assume it's because it's still all in one table.