You can't. This is what relational data is all about. If you deleted the member master record, you would then have records in related tables that reference a value that no longer exists.
Well, i said you can't, but if you make some changes you can. You can change the relationship to include CASCADE DELETE (you'll have to drop and recreate the relationship between the member master table and the other related tables). This will let you delete the record from the member master table, but then it will also delete all reldated records in referened tables.
You can do that, or, you can remove the relationships all togehter (I WOULD NOT RECOMMEND THIS).
Again, this is what relational databases is all about. Keep the integrity of the data clean.
Hope this helps...
Author - Professional SQL Server 2005 XML