Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Join Tables

Discussion in 'Information Technology' started by modo8, Nov 3, 2005.

Tags:
  1. modo8

    modo8
    Expand Collapse
    Guest

    I have a many-to-many relationship between tblPlanInfo (with PlanID the
    primary key) and tblProjectInfo (with ProjectID the primary key). To join
    them, I have tblPlanJoinProject.

    *****What I want to have happen (from most important to least important)*****
    1.) I want a user who is looking at the plan details (in frmPlanDetails) to
    see a list of Projects associated with that Plan, along with some basic
    information for each of those Projects (such as Project Name and Status)
    2.) I want the user to be able to associate other (new or existing) Projects
    that may need to be added to this list, or to remove Projects from the list.
    They shouldn't be deleting the project, only the association with that plan.
    3.) I want all the information seen to be accurate and up-to-date.

    I’m hoping someone can point me down the right path to accomplish all these
    goals.

    Currently, I'm using a subform in continuous view that's based on
    tblPlanJoinProject. This allows me to easily add or remove associations.
    However, the additional information that I want to display is maintained in
    tblProjectInfo. The continuous view prevents me from using another subform
    or list box to display the information from a query; instead, I use a DLookup
    to copy the information from tblProjectInfo to otherwise useless fields in
    tblPlanJoinProject. Once in tblPlanJoinProject, the information remains
    static, so it won't display any updates made in tblProjectInfo (I have an
    OnOpen event for frmProjectDetail, but this only updates the first Project
    listed, not all of them).

    I know I could use a list box or combo box based on a query to display
    updated information (accomplish goals 1 and 3), but don't see how I can add
    or delete associations with this method (goal 2).

    So again, any help is much appreciated.
     
  2. Loading...

    Similar Threads Forum Date
    Sone Bhambhani Joins Sikh Philosophy Network! New SPN'ers Today at 9:11 AM
    Gigi S Joins Sikh Philosophy Network! New SPN'ers Yesterday at 10:44 AM
    Khalis International Joins Sikh Philosophy Network! New SPN'ers Nov 23, 2016
    Gurdeep Kaur Joins Sikh Philosophy Network! New SPN'ers Nov 22, 2016
    Arshdeepsingh Joins Sikh Philosophy Network! New SPN'ers Nov 22, 2016

  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Check Access Help / your Access book on Subform.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "modo8" <modo8@discussions.microsoft.com> wrote in message
    news:400CDF40-3579-409B-9874-4B00E7FEADAF@microsoft.com...
    >I have a many-to-many relationship between tblPlanInfo (with PlanID the
    > primary key) and tblProjectInfo (with ProjectID the primary key). To join
    > them, I have tblPlanJoinProject.
    >
    > *****What I want to have happen (from most important to least
    > important)*****
    > 1.) I want a user who is looking at the plan details (in frmPlanDetails)
    > to
    > see a list of Projects associated with that Plan, along with some basic
    > information for each of those Projects (such as Project Name and Status)
    > 2.) I want the user to be able to associate other (new or existing)
    > Projects
    > that may need to be added to this list, or to remove Projects from the
    > list.
    > They shouldn't be deleting the project, only the association with that
    > plan.
    > 3.) I want all the information seen to be accurate and up-to-date.
    >
    > I'm hoping someone can point me down the right path to accomplish all
    > these
    > goals.
    >
    > Currently, I'm using a subform in continuous view that's based on
    > tblPlanJoinProject. This allows me to easily add or remove associations.
    > However, the additional information that I want to display is maintained
    > in
    > tblProjectInfo. The continuous view prevents me from using another
    > subform
    > or list box to display the information from a query; instead, I use a
    > DLookup
    > to copy the information from tblProjectInfo to otherwise useless fields in
    > tblPlanJoinProject. Once in tblPlanJoinProject, the information remains
    > static, so it won't display any updates made in tblProjectInfo (I have an
    > OnOpen event for frmProjectDetail, but this only updates the first Project
    > listed, not all of them).
    >
    > I know I could use a list box or combo box based on a query to display
    > updated information (accomplish goals 1 and 3), but don't see how I can
    > add
    > or delete associations with this method (goal 2).
    >
    > So again, any help is much appreciated.
     

Share This Page