[AccessD] I should be able to do this

Why store the counselor name in the student table?  Why not just store the  
id and use a join when you need the name?  That way if the counselor's name  
changes (marriage, divorce, whim) you don't need to run around updating  
student records. 

Steve Goodhall, MSCS, PMP

-----Original message-----
From: Tina Norris Fields <tinanfields at torchlake.com>
To: DatabaseAdvisors-Access <accessd at databaseadvisors.com>
Sent: Sun, Dec 4, 2011 18:47:04 GMT+00:00
Subject: [AccessD] I should be able to do this

Dear Friends,

Okay, I have a form with a combo-box for selecting the counselor who 
will be assigned to the student whose record is displayed in the form.  
Once that is updated, I want the matching name of the counselor to 
placed in the student's record.

So combo-box is looking into the tblCounselor, which has two fields 
Counselor_ID and Counselor_LName.  Once the choice is made, I want to 
update the field Stu_Counselor in the tblStudent with the name found in 
tblCounselor.Counselor_LName.

I'm writing gibberish in my AfterUpdate event and I need to be rescued.  
Any help waking up my brain?

Thanks,
T

-- 
Tina Norris Fields
tinanfields at torchlake.com
231-322-2787

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com