Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement