Re: Linking Tables


"Ryan''s Girl" <RyansGirl@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht news:245ADD0F-7638-499A-8061-A93C3248CEAC@xxxxxxxxxxxxxxxx
It created a relationship but it will not let me Enforce Referential Integrity.
It says"No unique index found for the referenced field of the primary table.

We guess that you need to create the needed unique index...

==> Make sure the referenced field is a Primary Key field.
In table design click on the 'key' in the toolbar.

BTW: an inventory database is not at all that easy!
I guess that you are going to need much more help on this, but please beware of this guy Steve !!
Steve is a notorious job hunter in these groups, always trying to sell his services.
http://home.tiscali.nl/arracom/whoissteve.html

HTH
Arno R
.

Relevant Pages

  • Having trouble with createRelation?
    ... "No unique index found for the referenced field of ... ' Each requisition has a vendor ... I get the error on the append statement. ...
    (microsoft.public.vb.general.discussion)
  • Table Relationships
    ... No unique index found for the referenced field of the ... >>I have two tables relating where one houses data for ... >>student information and one houses attendance for the ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Having trouble with createRelation?
    ... > I'm trying to use createRelation on an existing database. ... "No unique index found for the referenced field of ...
    (microsoft.public.vb.general.discussion)
  • Re: Creating Relationships
    ... referenced field of the primary table" and I can not create the relationship. ... The fact that you do not have a unique Index (such as a Primary Key) ... John W. Vinson ...
    (microsoft.public.access.gettingstarted)