Referential Integrity

2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 24, 2009   (RSS)

By pothompson - March 24, 2009

If I have create a new section, say for products that has a list field for category which is populated from another section where I specify categories, is it possible to stop deletion of a category record if it's used in one or more of the product records?

Thanks,

Paul.

Re: [pothompson] Referential Integrity

By Dave - March 24, 2009

Hi Paul,

You can't do that, no. But you can disable the "erase" link for a whole section under: Admin > Section Editors > Advanced > Disable Erase [_]

This is useful for other cases as well such as when you have a section of fixed pages (About us, etc) that you might load by record number on the site and you don't want the end-user to erase them.

Another note on referential integrity would be to make sure you use the "num" field as the value (and title, name, etc as the label) when having a list field load values from another section. Otherwise when you change the category name you'll lose the reference.

Hope that helps!
Dave Edis - Senior Developer
interactivetools.com