no unique index

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello, can someone explain clearly why i'm receiving this error when trying
to create realationship:
No unique index fouund for reference field of primary table.
I've searched this on the knowledge base and learned that the cause
"The order of the primary key fields in Design view of the table is
different from the order of the fields in the PrimaryKey index."
but when I reorder the fields I received this error:
Invalid field definition "" in definition of index or relationship

Thanks in advance.
 
Open the table in design view and look in the column to the left of the field
name that you say is your primary key. Is there an icon there that looks
like a key?

If there is not key then it is not set as the primary key. Click on the
toolbar icon that looks like a key and save.

If you get an error message saying you have duplicate then run a query to
find the duplicate and delete as necessary so as to be able to set your
primary key.
 
Back
Top