I am new to asp.net
i have developed one web application using c# (Asp.net)
i have one citymaster.aspx and citymaster table.
user used to add record from citymaster.aspx in citymaster table.
in citymaster table i have three fields : cityid, cityname, is_deletestatus
when user enter new city record like (1, "NewYork", 'N')
Note : 'N' means record is active not deleted.
If some one deletes record from citymaster.aspx page, then instead of deleteing record physically from citymaster table i just used to change the is_deletestatus field to 'Y' (means that record is deleted)
now i also have studentmaster table in which i have cityid field.
so if someone used to delete city from citymaster then i need to check whether that city is allocated to any student record. if allocated then i dont even want to mark it 'Y'. (just as cascading constratint)