Cascade Update Related Fields

[Steven W]

I am trying to create relationships between several tables
using ProjectID as the link from the Master table to the
childrean. I am able to enforce referential integrity but
cannot cascade update fields. the error msge
states 'invalid field definition 'ProjectID' in definition
of Index or Relationship. When press 'Help' the mesge
states either misspelling or linking on OLE or memo. the
latter is definitely wrong (autoNo). and I have tried
deleting and reentering the Project ID field several
different ways but still the same problem.
any advice gratefully rec'd
SW

 

[MacDermott]

If ProjectID in your child table is an AutoNumber, it cannot be Cascade
Updated.
You might consider changing it to Long.

HTH
- Turtle