Re: Creating Relationships
On Wed, 15 Feb 2006 12:39:31 -0800, "vgarr"
I am trying to create a one to many relationship between two tables and I
keep getting this message that reads "no unique index found for the
referenced field of the primary table" and I can not create the relationship.
What is causing this error message to come up?
The fact that you do not have a unique Index (such as a Primary Key)
on the field in the "one" side table that you're using to create the
Either make that field the Primary Key by opening the table in design
view, selecting the field, and clicking the "key" icon; or (if you
need to join on a field other than the primary key) set that field's
Index property to a unique index.
John W. Vinson[MVP]
- Re: Composite unique key with some fields that are null
... If you have an AutoNumber for primary key, ... You can make a composite index on the fields that contain nulls, but I don't think making it a unique index is a good idea. ... If you do need to create a unique index where some fields are known to have no value, you can use a zero-length string (zls) instead of a Null. ...
- Re: Are Primary Keys Necessary?
... I have a table called with CompanyID as ... MemoDescription, but no primary key. ... to keep your database performing at its best you would want an index on ... The only difference between a PK and a unique index is that a unique index can ...
- Re: New arrivals (II)
... multiple; and what I need to get back is a list of items, ... primary key (i.e. unique index) on keyval.id ... INSERT INTO item(id, colour, weight) ...
- Re: Table Connection
... If it's the primary key (or a unique index), it knows that you can only have that value in ONE record, so it determines that's the ONE side of the relationship. ... For example table1 and table2. ...
- Re: PayPeriod table
... Get rid of the ID (which I assume is the primary key). ... Put a unique index on the pay_period_end_dt. ... choose one candidate key to declare as PRIMARY, ... Do not create the column PayPeriod at all. ...