relation between two tables

Question

hi
there is a relation between two my tables in sql database . i dont want CasCade state. i wanna delete a record from tabal1 but i'll encounter a error because of relation and  NoAction State.
in fact i wanna have permisssion of deleting data from tabal1 without influense on table2.
 is it possible?