Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Angry Unanswered: Relationship Help Needed

    The subject sounds kind of like my personal life....

    I am using Access2000 and am making a database to track "incidents" within my small company.

    There are 5 tables (of 15) that have the same field called Incident Number (IR_Number).

    I have the the data type set as AutoNumber and would like to enforce referential integrity with cascading updates and deletes.

    The problem that occurs is that when I attempt to do this I get the following error; "Invalid field definition 'IR_Number' in definition of index or relationship".

    Any suggestions?

    And while I'm pretty technically adept, I'm not a "real" programmer so if you suggest that I change the code let me know how to access it.

    Jacque

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Jacque,

    Only 1 of the tables should Ir_Number be an auto number field.
    That should be the first table to have a new row added. All of
    the other tables with IR_Number should be of data type LONG.
    Once you have that set, the other 4 tables should be linked to
    the table containing the auto number field.

    Mark
    Inspiration Through Fermentation

  3. #3
    Join Date
    Sep 2003
    Location
    Spokane, WA
    Posts
    81

    Thumbs up Yea!

    It worked!!

    Thank you so much!

    As I get deeper into this project I'll probably ask more questions. But that one had me stuck.

    Again, thanks!

    J

Posting Permissions

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