I need a field that can handle one entry or multiple entries. How do I do this?

[SomeGuy]

For example: The form is for entering project info. The person who heads the project may collaborate with one person. This means I only need the collaborators field to accept one entry.

However, if the project leader has 10 collaborators, the collaborators field needs to accept ten entries. How can I do this?

Another problem that arises: I cannot have a table to accept this info that has countless columns for collaborators (eg coll1, coll2, coll3, etc). I assume that each collaborator should be in a separate entry (separate row), associated with the project number or the project leader. How do I make each collaborator a separate entry without having to re-enter all the project data every time?

I appreciate any suggestion here. =+}

 

[BarkerD]

You would need to create a table with two fields.

ProjectID
Collaborator

You would place these fields in a subform of your main project form so that you can add multiple collaborators for every project.

Join the forms on the ProjectID field, and set cascade update in your relationships so that if a project numeber is changed, the related information is also changed.

By relating the Project Table to the Collaborators table, you do not have to re-enter the project info for every collaborator on the project. The ProjectID field in the Collaborators' table references the Project table.

Hope I haven't been too vague.

Regards,
Duane Barker

[This message has been edited by BarkerD (edited 09-26-2000).]

 

[SomeGuy]

Thanks for the fast reply. This has had me stumped for awhile so its nice to get some fresh perspective.