General information
Category:
Coding, syntax & commands
Title:
RI fails when restrict is put on updates
I am unable to add a record in my address table unless I change my RI code from "Restrict" to "Ignore" for updates. Here's the scenario:
I have a relationship set up between my address table and an address type table, where the address type table contains simple integer codes representing Business, Home, Mailing, etc. My form contains a combo box where the user selects one of these types from the address type table, and I want to write its code into the address table. When I got the error, I started stepping through the RI code, and saw some values which looked like the insert was probably causing the problem (it looked like the code was looking for a childid of "0" in the parent). I decided to test by changing restrict to ignore. After doing that, the add worked fine. I went to look at the added record to see if there was a 0 in the address type field (there shouldn't have been), and there wasn't. Since I'm selecting from a combo box, I can't see why this might have failed.
I'd appreciate any insight into this problem.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only