Cascade updating

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hello, I have a one to many Relationship, Force
Referenctial Integrity and Cascade updating (not cascade
deletes).
the One-side shows Company names
The Many-side shows a Contact Type: Supplier,
Manufacturer, Customer, etc.

If I ManufacturerA & SupplierA belong to Company A I want
to be able to change Company A name and then this to be
reflected in ManufacturerA & SupplierA and don't to get
instead and Error Message.
I set Cascade Updating and I thought that was enough but
is not working. The tables are External (link tables)

thx
gr
 
Not sure I understand. I didn't think it was possible to use the
Relationships window to set cascading updates (or deletes) on external
(i.e., linked) tables ... and for good reason!

If a table lives in an Oracle db, or a SQL Server db, or ..., you should NOT
be able to tell it how to react to changes internal to an Access db that is
linked. The other "owners" of those external tables might have reason to
not want those (apparently) invisible changes.
 
Is a Splitted Database.
I set the Cascade Updating in the back end tables but I
can't see this in the front end.
 
Jumping in (not having read the whole thread): relationship information is
only relevant to the db where the tables reside. Note sure that it
will/should be visible in other db's that link to that db.

HTH,
TC
 
Back
Top