Deleting lookups that are used by other Business Objects

Deleting lookups that are used by other Business Objects

Old forum URL: forums.lhotka.net/forums/t/10632.aspx


jhardman posted on Tuesday, August 23, 2011

Lookups can be deleted.  However they should not be deleted if they are used by other business objects otherwise there will be referential integrity issues.

E.g. in ProjectTracker there is the BO ResourceAssignment.  It has a Role property.  If a ResourceAssignment record is created with Role=0, then the BO for Role should not be able to delete Role=0 since it is in use.

How do you guys handle this?  Do you try and delete and then catch the database error that will occur and then display a message?

Copyright (c) Marimer LLC