Member Avatar for HunainHafeez

Hi, guys i m already done with DB part of my project !!! but confused here !!! (Check attached image)

Admin will enter all relevant details in applicant-scrutiny table for each user ........but i want that value for each userid (foreign key) should be copied automatically !!! NOTE: USER table has bee already filled

e.g all fields are filled....

sscpercentage= 90

fsc marks=800

........so on but at last i have a field userid and i want to fill it by its own for that user for which i m entering details.

so help me guys ? check attachment

my_DB_image

msdn.jpg 50.38 KB
  • 2 Contributors
  • 9 Replies
  • 125 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by HunainHafeez
Member Avatar for AleMonteiro

For each user on tblUser you want to create an record on tblApplicantScrutiny, is that it?

Member Avatar for HunainHafeez

u got me 100% rite.......yes xctly !!!

Member Avatar for AleMonteiro

So, I suggest you to make an store procedure to create the records for the existings users and then create a insert trigger at the users table for the new users.

Member Avatar for HunainHafeez

rite !!1 and any other alternative? ......i m managing it from Asp.net

Member Avatar for AleMonteiro

Sure, there's a lot of them, a couple are:

  1. You can do it all in asp.net.
  2. You can work only with triggers (ie.: a update trigger on Users that will check if the user has a application, and if it doesn't it'll create one).
  3. You can do the initial insert in asp.net and the new ones at the trigger.
Member Avatar for HunainHafeez

@Gr8 man !!! good job !!!
i will go with the 1st option !!! bcz i don't know that y ? but i always hesitate usinf triggers !!!
so i will try to make my own logic !!! and tnx man !!!

Member Avatar for HunainHafeez

how much dynamic a template could be ? dynamic , in terms of modifications !!
e.g i purchase a template for my website and further i want to modify it for my own satisfaction and requirements ? that how much it could be modified ? At large extent ?

Member Avatar for AleMonteiro

Triggers can be dangerous, if you use it wrong, but for somethings is the best option.

And please, post your new question in a new post and mark this as solved.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.