Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trouble with subform (Access 2000)

    I have an access database that has 3 tables:

    Person Organization
    ----------- --------------------
    PersonId OrganizationId
    name OrganizationId


    Mapping
    ---------------
    PersonId
    OrganizationId


    I have 1 to Many relationships set up between Person and Mapping, and between Organization and Mapping. I have a Person form as the main form, and an organization form as a subform. I can't get the Mapping table to be populated. Is it possible to do this with a Form and a Subform like this, or is something else needed?

    Thanks,
    Rich

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Trouble with subform (Access 2000)

    You will need the Person as the Main form (as you have it) and Mapping as the Subform.
    I would assume that the Organization table would have it's own form to maintain organizations.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trouble with subform (Access 2000)

    since the mapping table only has the two ids (PersonId, OrganizationId), is there a way to hide it? There's real reason for the ids to be displayed because they don't mean anything. For the organization form, how does it get linked to the mapping table if its on another form?

    Thanks

  4. #4
    New Lounger
    Join Date
    Dec 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    One thing about the organizations

    The organizations will not be preloaded. The user will be the one typing them in, so I can't just put them on in a combo box.

  5. #5
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Trouble with subform (Access 2000)

    Organization is a table that is a list of Organizations, right?
    Has the Organization table got the following fields:
    OrganizationId
    Organization (which would be the name of the Organization I presume, not as you had defined it as above)

    Are you trying to input Organizations (on the Subform) for People (Main form).
    If so, then the Organization would be entered by Combobox and what would show is the Organizations name on the Subform, not the ID (the ID is saved in the Mapping table behind the scenes). You can quite easily use the Combobox wizard to set this up.

    Yes, I am assuming that the Organizations are already pre-entered, however, you could use the NotInList event on the Combobox on the Subform to have these entered at this point if you wish.

    Hope all this rambling makes sense.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  6. #6
    New Lounger
    Join Date
    Dec 2002
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks Pat

    Thanks - Hopefully I can get this to work now.

Posting Permissions

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