error #3609- no unique index found for the referenced field for the primary table

[Clark Polk]

I have access97 running under windows95.

I will give an overview of what I have done so far.

I imported two .dbf files.
primary/base table is za_volun
fields of interest: key, v_suffix,v_lname, v_fname,
tot_hrs

relation table is za_part
fields of interest: key, v_suffix, svce_code, year, hours

I want to create a one(za_volun) to many(za_part).. join #3, and
enforce referential integrity so I don't have to, and use cascading
update/delete option. Before doing any of the below I ran the find
unmatched query to look for childless records in za_part and found
a lot of them so I deleted them.. but I could only use the key field
I reran the find unmatched query and it returned no rows.
--
--
as the way it stands now.. there is duplicate data in the key field
for za_volun.. the main table
12345 01 pam polk 67
12345 02 clark polk 98
Before creating the primary key on key and v_suffix, I ran the duplicate

query on key and v_suffix and it returned no rows so I knew I could
use it as a primary key
primary key -> key and v_suffix
this as you know creates a unique index. I verified this in
tools - documenter - table and saw under table indexes that:
Name: Primary Key
Primary: True
Required: True
Unique: True

Then I went to relationship window, show table on za_volun, za_part,
took the key field from za_volun(which was on the left side) and
put it to the foreign key field to za_part(on the right), selected
join type #3, checked referential integrity, checked cascade
update/delete ,and received the message:

NO UNIQUE INDEX FOUND FOR THE REFERENCED FIELD OF THE PRIMARY TABLE

Can someone help me with what I am not doing correctly? From what
I can see it says this is a unique index.

Any help would be appreciated

Thank you

Pam Polk

[Monica Perez Cuevas]

> NO UNIQUE INDEX FOUND FOR THE REFERENCED FIELD OF THE PRIMARY TABLE
>

You should go to the "design" of your primary table ("za_volun").
Go to "View" and then "Indexes". You'll find that you've got more than one.
Delete everything unless the one that says "Primary Key".

When you create a Primary Key an index is created but Access don't
automatically delete
the old one.

Monica Perez.