Rotating questions?

[Smack]

I have a new task given to me by my boss. He would like to have a simple form created so that when customers place an order, a customer service rep can ask a question of the day. Ex. Delivery performance, product quality etc. He would like the following
1. Store the questions in a field or table.
2. Pull questions from the file in sequence.
3. Filter questions if they have already been asked of that particular customer, but remain active if it has not.
I hope this makes sense. Thank you in advance.

 

[ssecca]

This looks wonderful, it's not all that complicated, the desires of the user are well laid out. The only problem I have is, What is the question? I all seriousness what about theis project do oyou need help with? Do you need help with the design? Or the coding? or something else?

waiting to help
ssecca

 

[Smack]

Basic layout is very simple. I don't know how to write code. When a CSR opens up the form and selects the customer, I want the next question in line to pop up. If it is someone who orders frequently, in one month, they might be on question 7. On the other hand another customer may only be on number one. There would be about 20 or 30 standardized questions for the form to pull from. I don't know how to have the system "know" which question a customer is on.
Make sense?
Thank you for the quick response.

 

[Smack]

Bump

 

[Smack]

Bump

 

[ssecca]

One way to approach this is to add a column to your customer table. Thsi column would be used to track the number of the last question asked. On the form that comes up you need to add a new field that is connected to the question table via a query that will pull only the next question. Something like...

Select Question From tbl_Questions
Where Q_No = me!lastQuestion + 1

Then have the opeator acnoledge that the question was in fact asked by pressing a button on the form this buttons on click event will advance the lastquestion field by one. The next time the customer calls back it will be looking at the next question.

Just keep in mind that you may have to handle what do do when a customer calls back more times than the number of questions you have.

Doing it this way requires minimum coding and only a slight retraining to your operators. Other options are available if this does not meet your needs.

Hopefully this will get you going on the right track.

Good Luck
ssecca

 

[Smack]

Thanks, I'll give it a shot.