LookUp Relationship
LookUp Relationship
I have two form Person and membership.I create a relation ship between these two table.Person_Id is parent field in Person and foreign field in Membership.If i deleted the one value of Person_Id from the table,It deleted that row but it will not delete the row from the membership table which contains the same personId,It delete only the value of Person Id.I want to delete the entire row which contains that Person Id
is normalization possible in zoho?
eg:
Person table
12 xx
13 yy
14 zz
membership table
12 x aa
12 x bb
13 y cc
if I deleted person Id 13
It shows as
Person table
12 xx
14 zz
membership table
12 x aa
12 x bb
y cc