B
Brook
Here is what I am trying to accomplish:
I have set up a Call Center database to track customer
calls:
I have frmCallCenter and frmDetails. When the user is in
the frmCallCenter they only see a call summary (CompanyID,
CallerName, and Company Name (company name is a drop down
box and CompanyID is filled in based on the Company Name)
when the user clicks a command button -- they see more
details on that particular call (type of call, date of
call, lenght call, call notes, etc).
I also have a tblSpecialNotices, that is based on the
CompanyID, and contains the company name and any special
notes that apply to that company.
What I am trying to do is set up a Message box that when
the user enters the Call Details a message box will pop up
giving them any special notes for that Company (based on
the CompanyId from the tblSpecialNotices and the CompanyID
from the frmCallDetails).
Hope this is clear and I hope someone can help,
Thanks,
Brook
I have set up a Call Center database to track customer
calls:
I have frmCallCenter and frmDetails. When the user is in
the frmCallCenter they only see a call summary (CompanyID,
CallerName, and Company Name (company name is a drop down
box and CompanyID is filled in based on the Company Name)
when the user clicks a command button -- they see more
details on that particular call (type of call, date of
call, lenght call, call notes, etc).
I also have a tblSpecialNotices, that is based on the
CompanyID, and contains the company name and any special
notes that apply to that company.
What I am trying to do is set up a Message box that when
the user enters the Call Details a message box will pop up
giving them any special notes for that Company (based on
the CompanyId from the tblSpecialNotices and the CompanyID
from the frmCallDetails).
Hope this is clear and I hope someone can help,
Thanks,
Brook