Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autonumber PK (2000)

    I'm trying to get an auto number primary key in my main table to relate to my second table, but I can't seem to get all the update options or even to enforce referential integrity. Am I making a basic mistake here?
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumber PK (2000)

    E&B
    You have RNDNo in table 2 set to integer, Change this to Long Integer in the table properties, you'll have all the join options then.
    You'll have to delete the existing relationships to allow table design changes.
    (Try it on a backup first)

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autonumber PK (2000)

    You know, I was sure I tried that. Never mind, many thanks Dave. That's a pint I owe you
    Paul

Posting Permissions

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