Thank you very much for the valuable response.

@jack-2 Corbett, would you elaborate your suggestion. I want to mention one more thing i m not using any of the...

Thanks for the suggestion. !!!

But sorry i can't hire you 🙂

Thanks again, you put me in right direction !!!

What i know it will be the subscription based ERP (initially following modules,Customer,Membership,Roles,Permission, HR, Finance in its beta edition and later on other modules will be created)

Client will register for...

Hello thanks for the response.

The scenario is as follow:

ERP is web based application so there will be many different organization going to use it.

1. Yes: ERP modules need strict...

Thank you very much !!!!

ado.net. i hape m clear

More accurately there is many to many relation ship.

so table should in such a manner that

whenever a Machine is selected all the Brand of that Machine should be show...

yes like the way sir u have written ,feature with 7 no.

Well very much appreciated the help u giving me Thanks n god bless.

My problem is as follows ;

I have 3 tables name: (i) Machine where

...

Thank you for your valuable suggestion. I should look the broader aspect.

I will try it again with Stored procedure.But it will be helpful for me if i get the codes.....

Thanks...

Thanx sss.. for ur suggestion. but i have to do it with help of trigger only. so pls pls tell me what modification i have to do. pls.