Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

AutoNumber data field

Discussion in 'Information Technology' started by tikchye_oldLearner57, Jul 28, 2006.

  1. tikchye_oldLearner57

    tikchye_oldLearner57
    Expand Collapse
    Guest

    hello community

    Can anybody kindly explain to me this statement:

    "In Access, user cannot use an AutoNumber data field to enforce referential
    integrity between tables"

    however

    when I created two tables, and both tables I allow Access created the
    Primary keys for me.

    Thereafter, I use the 1st column, which is the Autonumber, I created a Link
    between the two tables and I also able to Enforce Integrity ?

    why is that so that I can use AutoNumber to enforce integrity ?

    I am using Access 2003

    thanks community

    --
    oldLearner57
     
  2. Loading...


  3. Arno R

    Arno R
    Expand Collapse
    Guest

    "tikchye_oldLearner57" <tikchyeoldLearner57@discussions.microsoft.com> schreef in bericht news:B2D4228E-5FD1-4EB3-8DC9-60136D827184@microsoft.com...
    > hello community
    >
    > Can anybody kindly explain to me this statement:
    >
    > "In Access, user cannot use an AutoNumber data field to enforce referential
    > integrity between tables"


    I guess this must be understood as:
    You cannot use an Autonumber *at both sides* of the relation.

    You definitively *can* use an autonumer (and a long integer at the other side) to enable RI.

    Arno R
     

Share This Page