It is very simple procedure..

Suppose I am having

Table LoginMain(LoginNo int PK,LoginName varchar(300))

TransactionMain(TransNo Pk,LoginNo int FK of LoginMAin)

TransactionMain2(TransNo Pk,LoginNo int FK of LoginMAin)

TransactionMain3(TransNo Pk,LoginNo int FK of LoginMAin)

.

.

.

and so on.

Now...

I am doing same. i am deleting an entry for which there is no row in its child table or in referencing table,though i am getting same error.

The query processor...

Yes i am having 300+ tables which are referencing a single primary key of a table.

I have few more question which is raise after getting replies.

1. Should i create such a huge number of foreign keys,that means 300+ tables having foreign key with single primary...

I have one table for login Details

I am using this with each records to know that who has created any entry. and i am having more then 300 tables.

As i...