Results 1 to 3 of 3

Thread: relation

  1. #1
    Join Date
    Sep 2007
    Posts
    6

    Unanswered: relation

    i have a table_ A with the attributes (FirstName, LastName, County)
    and a Table_B with the attributes ( FirstName, LastName, County, Phone)
    The primary keys on both tables are FirstName and LastName.
    Access allows to have relation between them , but not to enforce integrity.WHY?

    i don't want to have a field(row) on table_B that don't much the field(row)FirstName, LastName on tableA.

    THANKS

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Your current design only allows for one person called "John Smith" to be entered with integrity... Do you think that's wrong?
    George
    Home | Blog

  3. #3
    Join Date
    Sep 2007
    Posts
    6

    no but access reports as problem when i try to put the ralations

    no but access reports as problem when i try to put the ralations

Posting Permissions

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