few problems with phone log database, thx for any help!

[Ren]

I have a phone log database, (i may have posted this b4, but i cannot find
it) heres the setup:

date
time
For ( drop down table, single column)
Calling (drop down table, single column)
Company (drop down table, single column)
Return Number
Nature of call (memo)
Delivered ( drop list:msg taken, desk, telemarketer, lost conection, etc.)
Follow-up Actions (memo)
(atuo #)key*
category (table, dropdown): work orders, customer inqurierys, current
customer services, etc.

(office 2000)


Ok, what I'm trying/wanting to do:

1. when someone named 'bob' calls, i want to be able to seltect 'bob' from
Calling feild and any Company a 'bob' works for comes up, giving me few
options to have to look thru if more than one. ie , it automatcially looks up
Bob's Carpet and selects it the company field for me- saving me precious
seconds lol

2. Is it possible to have the time and date fields (seperate) to
automatcialy update themselves whenever i've gone to a new one, or if its
sitting for a while, it'll upate it when i start typing in the for field?
...and it'll stay the right time and right date on each record because i print
a report at the end of the week??

3. When someone new calls in or someone that just isn't in the dtb yet, is
there a way to save them into the dtb? like atm i have to print a list of
everyone who's called and then go back into the tables and stuff to type
everything in..with the calling, for, & comapny feilds, which just wastes a
lot of time i can be doing something else. and it'll work with question #1??

kinda please be simple in explaining. i've been working w/ access for nearly
8 years but i'm still learning everyday, i know enough to get me by but not
enough to say i know alot.

THANKS ALL! ;D

 

[mscertified]

(1) Your company field would be a combo box and after you have updated the
first name field you would just need to set up the query feeding the company
combo box and then do a requery.
(2) Dont understand the need for this, just set the date and time when you
write the record to the table.
(3) Just set up the fields on your form to add the new person and have a
command button to trigger the insert to the table.