Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    NJ
    Posts
    4

    Unanswered: Relationships-Subdatasheet etc

    Hi,

    I know I am probably missing something very simple here but I hope someone can set me straight to stop my misery. I have one table with about 700 people (first and last name fields). I need to create other tables with additional information about each person but I don’t want to retype all the same information (first & last name) for each table and I don’t want to use the lookup wizard to select a name one at a time.

    What is the best way to create other related tables and how?
    Maybe another way to stating the same thing is how can I populate a new table with information form an existing table?

    Thanks
    Jim
    Last edited by jdolan2726; 10-24-03 at 19:40.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    In the master Table create an autonumeric field (keyName), this field must be the master key of that table.
    Create a second table and relationship both table with the keyName
    field.
    Saludos
    Norberto

Posting Permissions

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