Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    28

    Unanswered: how to open two table

    Hi,
    I have two tables .One is the main table and other sub- Table.
    The main table contain many information very one has Idno.
    And sub-table contain personal information related the holder idno.
    What I want when I open main form special in Idno field I want the sub-table show his information

    For example.
    When I open main table and I go to idno 10 the sub-table must open and show his personal information.

  2. #2
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Create a form based on your main table, then insert a sub-form based on the sub-table. When you use the wizard, Access will suggest the linking criteria between the two, and this should be your ID number.

    Hope this helps...

  3. #3
    Join Date
    May 2002
    Posts
    28

    Hi,

    Thanks alot for u help one more question.that is
    is in mainform i click Id no 5 it must show the records in sub-form.

    thanks

  4. #4
    Join Date
    Oct 2001
    Location
    Bay Area, CA
    Posts
    117
    Use the record selctor on the bottom of your form to go to record #5, don't type in #5, because this will change your current record.

    If you need to make you record lookup more fancy, there are other ways to get to a specific record.

    Hope this helps....

Posting Permissions

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