Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010

    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.

    Three questions:
    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?

    Hope that makes sense, thanks!

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Sounds like you could graphically represent this relationship with a subform.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts