Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jan 2004
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Populating Cross-Ref Table by Form (2003)

    Newbie problem I hope someone can help me with:

    I have 2 lookup tables:

    tblCollaborantLkUp
    Collaborant_ID_#
    Collaborant_Name

    tblInstitutionLkUp
    Institution_ID_#
    Institution_Name

    and a cross-reference table that holds the matches between Collaborants and Institutions.

    tblCollaborantInstitutionCrossRef
    Collaborant_ID_#
    Institution_ID_#

    tblCollaborantLkUp and tblInstitutionLkUp are populated. tblCollaborantLkUp is related one-to-many via Collaborant_ID_# to tblCollaborantInstitutionCrossRef . Similarly tblInstitutionLkUp to tblCollaborantInstitutionCrossRef.

    I need to design a form that allows users to make associations between between Collaborants and Institutions in tblCollaborantInstitutionCrossRef.

    I thought this would be easy, using subforms and combo boxes, but I can't get it to work. Does anyone have any thoughts as to a better approach?

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Populating Cross-Ref Table by Form (2003)

    See the sample database attached to <post#=364203>post 364203</post#>. It demonstrates how to implement a many-to many relationship in a form and subform.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Populating Cross-Ref Table by Form (2003)

    Base the form on the join (cross-ref) table. Use an unbound list or combobox for tblCollaborantLkUp and another for tblInstitutionLkUp. After the user has made a selection from each list or combobox, let them click a button to create the join record. Then you can either run a query that references the form to append a new record to the join table or you can do it in code.
    Charlotte

  4. #4
    Lounger
    Join Date
    Jan 2004
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Populating Cross-Ref Table by Form (2003)

    Thanks, both of you. I will take a look at these solutions and get back to you with my results. And I thought it would be straightforward!

  5. #5
    Lounger
    Join Date
    Jan 2004
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Populating Cross-Ref Table by Form (2003)

    Yup. Worked. Thanks very much!

Posting Permissions

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