9

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.

Improve this question

1 Answer 1

Reset to default
5

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

mockup

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.

Improve this answer
4
  • 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, 2013 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, 2013 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.
    – Joshua Barron
    Mar 21, 2013 at 18:08
  • Yea that's true. I should think of limiting user control or create a UI for complete control
    – Atheos
    Mar 21, 2013 at 19:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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