How can the engine delete a record with Relationships and enforce intergrity
set on a middle table and not the rest of the records. Example: Table1
Autonumber set to table2 value as table1 autonumber value, table2 Autonumber
set to many other tables value as table2 Autonumber value. Table2's record
gets deleted when the user is just moving from field to field on a form and
none of the Child reocrds are missing. No code to delete any records is being
processed. This is becoming a major- major issue with 2007 Access. We have a
front end application with linked tables to the database that the records are
disapearing. This is happening on many different Widows opperating system and
configurations.
|
Similar Threads
