Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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
    Harman Tuteja Joins Sikh Philosophy Network! New SPN'ers Dec 25, 2016
    Gurnam Kaur Khalsa Joins Sikh Philosophy Network! New SPN'ers Dec 22, 2016
    Barkha Joins Sikh Philosophy Network! New SPN'ers Dec 22, 2016
    Avaa77 Joins Sikh Philosophy Network! New SPN'ers Dec 20, 2016
    Learningsingh295 Joins Sikh Philosophy Network! New SPN'ers Dec 20, 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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page