Unanswered: Is it possible to add new form items while form is in Form View?
Now what I have is two tables: Resource, and Project.
What I want to do is be able to add many resources (with a percent required) to many projects.
My initial thought was to create a table ResourceOnProject with ProjectID, ResourceID, ResourceName, PercentRequired. I then created a form with only Resource Name, and Percent Required displayed as a Multiple Item form. I then thought I should add this form into my Project form so my-coworker could select between one to many resources on the project.
1 - Is this the best approach?
2 - Can I create a Form and each time a Resource is selected, a new Resource drop down is displayed?
3 - When clicking on the Add Project, or Update Project buttons, how will I update my DB to record all of the proper relationships between projects and resources?