Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updated data in form HELP
- Thread starter CK8
- Start date
Hallo,
Your data is probably updating because there is a relationship between the fields in the underlying tables. This relationship has referential integrity enforced, and has Cascade Update Related Fields is set.
To stop this happening you need to redesign your database.
Remove the relationship to prevent the updates. This may, of course, affect your application in a myriad of other ways, any or all of which may be disastrous. It just depends on the design.
If you want to give more information, then we may be able to help further.
- Frink
Your data is probably updating because there is a relationship between the fields in the underlying tables. This relationship has referential integrity enforced, and has Cascade Update Related Fields is set.
To stop this happening you need to redesign your database.
Remove the relationship to prevent the updates. This may, of course, affect your application in a myriad of other ways, any or all of which may be disastrous. It just depends on the design.
If you want to give more information, then we may be able to help further.
- Frink
- Status
