I have some custom modules which each their own table.
Each module is set up as a private assembly and the tables have a relationship with rb_Modules as outlined in the documentation "Whitepapers - Rainbow Portal March 2003"

i.e. rb_Modules.ModuleID -> rb_imagealbum.ModuleID (for the error below)

If I try to remove a module from a tab whilst the module has data associated with it in the module's table (eg rb_imagealbum) then I get the following error:

DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_rb_imagealbum_rb_Modules'. The conflict occurred in database 'Rainbow', table 'rb_imagealbum', column 'ModuleId'

I can remove the module if there is no data.

This happens on all my custom modules that have their own databases, but not on any of the core modules (that I have noticed anyway) so obvciously I'm missing something in my code somewhere.

Does anyone have any idea what I'm missing?


This message is intended only for the addressee(s) and may be confidential. Access to this email by anyone else is unauthorised. Any opinions expressed in this email do not necessarily reflect the opinions of BCA. Any unauthorised disclosure, use or dissemination, either in whole or in part is prohibited. If you are not the intended recipient of this message please notify the sender immediately. BCA, Greater London House, Hampstead Road, London. NW1 7TZ. Tel: 020 7760 6500. This message has been checked for all known viruses by the MessageLabs Virus Scanning Service.