S
Seth Schwarm
Access XP (2002). Access 2000 file format.
I have a primary table with a primary key with data type
Long Integer and the index is set to Primary Yes and
Unique Yes.
I have several secondary tables related to the Primary
table via a one-to-one relationship. The linking field
is the same data type as the primary key mentioned above
and the index on the tables are Unique Yes.
I can create the relationship by dragging. I can set
Enforce Ref Integrity. But when I attempt to set Cascade
Update or Delete and then save that is when I get the
following error message:
Invalid field definition 'Field Name' in definition of
index or relationship.
I have been developing in Access for several years and
have never seen something like this for a relationship as
simple as a one-to-one.
All help is appreciated
Seth
I have a primary table with a primary key with data type
Long Integer and the index is set to Primary Yes and
Unique Yes.
I have several secondary tables related to the Primary
table via a one-to-one relationship. The linking field
is the same data type as the primary key mentioned above
and the index on the tables are Unique Yes.
I can create the relationship by dragging. I can set
Enforce Ref Integrity. But when I attempt to set Cascade
Update or Delete and then save that is when I get the
following error message:
Invalid field definition 'Field Name' in definition of
index or relationship.
I have been developing in Access for several years and
have never seen something like this for a relationship as
simple as a one-to-one.
All help is appreciated
Seth