Cascade Update Related Fields

S

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
 
M

MacDermott

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

HTH
- Turtle
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential Integrity for Lookup fields in tables 7
Table not updating 4
Enforce referential integrity when to use in relationship? 2
relational integrity is grayed out on 1-to-1 relationship 3
Error 3626-Can't force referential Integrety 3
cascading updates on date field 2
Relations on Tables 1
Cascade Update Related Fields Bug? 2

Top