AutoFill Data (1 Viewer)

MrDix

Honor Courage Commitment
Local time
Today, 05:21
Joined
Apr 22, 2005
Messages
10
Hello, I am creating a helpdesk support database. My question is for my Customer Form.
As I tested the form I realized that one of my Combo Boxes may not work cause the name may not be the same when the customer calls. Let me Explain:

The Combo Box is query from one table with 5 Fields:

CompanyID > PK
Company NumberID > unique Number
Company Name > Short Name
Company Number > telephone Number
Company category > Category Company belongs to

So, when the customer calls they may give another name for the company or just an abreviation.

what I did I created a pop up form which displays all records showing the NumberID; Name; Number; and Category, with a lookup txtbox to search for the customer by typing the company NumberID on a continues form.

Now,
Here the agent can actually do two things: One, the agent Can Update the company Phone Number and Category.
the second thing will be to either double click or select the right company and autofill the combo box or should I used a textbox instead of the combo box in my form.

P.S. Right now I using a Combo Box.

Thank you. Any help in the right direction will be great.

Mr. Dix
 

Users who are viewing this thread

Top Bottom