HOw to do not delete table value when some where using

Accepted answer

Use a boolean field for status of delete yes or no

i have one simple program , suppose, one building is there, have some facility, like Video Game, restuarents elc..

when some one using those facility so we can't delete from table...

thank you bro

While user delete row in store procedure update that row into isdeleted=1

and retriving data stored procedure will be select * Record where isDeleted=0

Please explain little bit about what do you mean by table value and what is your expected output?