Results 1 to 4 of 4

Thread: Relationships

  1. #1
    Join Date
    Jan 2002
    Location
    Maryland
    Posts
    2

    Unanswered: Relationships

    I created a database called "XYZ".

    inside "XYZ" was 4 tables.

    A, B, C, and D

    Table A was the main table.

    B was related to A, where multiple entries in B were related to one in A

    C was related to A, where mutiple entries in C were related to one in A

    D was supposed to be related so that when I changed from one entry in C to another, it would then change D. I also wanted it related to A, to prevent any possiblity that an entry in C could result in accessing the wrong entry in D.

    If D is related only to C is that possible?

    Also when I had D related to A, it seemed it would not change entries. B and C changed entries to reflect data that should only be filed under A. but D stayed the same as is it was independant of A.

    I can not seem to get D to change so that:
    "1 in A" = "Many in D" and "1 in C" = "Many in D"

    Any suggestions?

  2. #2
    Join Date
    Jan 2002
    Location
    At the Edge of America!
    Posts
    55
    Make sure your relationships are set up to Update.

  3. #3
    Join Date
    Jan 2002
    Location
    Maryland
    Posts
    2

    relationships cont...

    I think creating a new database and not having the relationships work means all the relationships are current. if not how did they get old when they were created only moments before?

  4. #4
    Join Date
    Jan 2002
    Posts
    5
    Come again?

    Okay, step 1, give your database and tables MEANINGFUL names, if its classified information, use examples in a non context sort of way, that way people who read your post will know what you are saying... That... its WAAAAAAAY to confusing!!

Posting Permissions

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