Subform instead of multivalued lookup

[drvo]

Hi



As most of people suggest, multivalued fields introduced in access 2007 should be avoided due to normalisation issues.
Thus I would like to create subform instead of multivalued field.
I have tables tblProjects and tblContacts and forms frmProjects and frmContacts. What I want is that on frmProjects I can choose which people (from tblContacts, more than one) worked on project, but without using multivalued fields.

Any ideas?

[ssanfu]

Don't know your requirements, but you could start with

a table ProjEmp

fields:
ProjEmp_ID (autonumber) PK
ProjectID_FK (long) (foreign key to projects table)
ContactID_FK (long) (foreign key to contacts table)

In the main form, there would be a sub-form with a combo box to select the employees (contacts).