Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    29

    Unanswered: Linking two table

    Hi

    I would like to link two tables, so that one is parent and the other one is a child table. When I drag the two fields to form a link, it is only the one-to-one relationship. I want to change it to one-to-many relationship, but fails. Why is that and how can I change it?

    Many thanx in advance

  2. #2
    Join Date
    Oct 2006
    Posts
    1
    The method of linking tables is based on the data within each table. One-2-One implies that the key fields are identical and are not repeated in each table. One-2-Many implies that they are identical, in Table 1 it is not repeated, yet in Table 2 it *is* repeated.

  3. #3
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    29
    Thanx for your reply, done 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
  •