It would be great to have ideas around how to approach below scenario.

User wants to delete a Item "X" from a table A. But item "X" is being referenced by multiple items from Table B , Table C and Table D.

Whats the best flow to allow user to delete Item "X" ?

we cannot automatically delete referenced items from Table B , C and D. We should let the user make that choice.


Present a warning to the user about the consequences of deleting item X, i.e.,


download bmml source – Wireframes created with Balsamiq Mockups

The 'consequences' could be a cascading delete (as I've shown above), or dereferencing X from the various related items (i.e., "Item One will no longer know about X"), depending on your use case.

  • I think this would work when we just have one item from each table being deleted. When we have for example Item 1 , 2 , 3 from Table A and Item 1,2,3 from Table B , this might not work well.
    – Atheos
    Mar 21 '13 at 17:20
  • May be something like "Table A 50items , Table B 30 Items , Table C 20items" in the box which currently shows "item One Item two Item three" .. Also what do you think about adding a "X" next to these table names which would enable users to click to delete all linked records from that table ?
    – Atheos
    Mar 21 '13 at 17:22
  • That could work - although if you're going to get much more complicated that that, you may want a dedicated UI for this type of action. Mar 21 '13 at 18:08
  • Yea that's true. I should think of limiting user control or create a UI for complete control
    – Atheos
    Mar 21 '13 at 19:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.