General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
I try to make a referential integrity on tables like this model:
1. table(A) master with 'iddoc' primary key
2. 2 tables(B & C) each with 2 fields related to primary 'iddoc' named 'iddoc1' and 'iddoc2'
3. build RI with RRR rule on all 4 relation
when I try to update a record in (A) wich does not have a related records in (B) OR (C) get error 'Ilegal recursion....' or if I try this from a form 'Variable iddoc2 not found'
What it's happening because 'iddoc2' is there and RI code is generated automaticaly; any solution?
Thanks
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