Results 1 to 2 of 2

Thread: Forms/tables

  1. #1
    Join Date
    Dec 2001
    Location
    Kansas
    Posts
    4

    Unanswered: Forms/tables

    I've created a couple of tables and a form. The Form is directly related to Table A. I've added a combo box to the form that pulls information from Table B. There are 3 other boxes that will pull information from the same record in Table B.

    Is it possible to have multiple fields populate when a change is made to the single combo box on the form? If so, where do I begin?



    Thanks,

    Jason

  2. #2
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama
    Posts
    12
    You only need to store the ID from Table "B" in the record in Table "A". The information you need from Table "B" can be pulled using a Relational Join between the two tables when needed.

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama

Posting Permissions

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