I need serious help

[IKNOWNOSQL]

Hi All

I really hope someone can help me. I am busy building a outbound database for my Call Centre. The problem is I know no sql so when it comes to writing queries etc I am dead in the water.

What I am am doing is this.

1. I have a select form where the agent will select
* Area
* Branch
* Job Title
* Employee Name

THis works fine but the next step is to take the selected information from this form to a second form, I cannot get right

Once that information is pulled over the next form should

* Review all transactions done by this have them displayed to the agent 1 by 1.


* Agent should have a option to state the outcome of the call and if the cusotmer is interested in giving the feedback he is calling for fill in the answer to 5 questions by rating them 1 to 5.

THis must be stored in a table for each month as it is a monthly process.

This is what i have so far. I am willing to pay someone to help me on this part.

[pdebaets]

if your first form is "Form1" and your table is "MyTable" and assuming that your field names on Form1 and MyTable are as indicated above, then you can create a 2nd form with the RecordSource property set to

Select * from MyTable where [Area] = Forms!Form1![Area] and [Branch] = Forms!Form1![Branch] and [Job Title] = Forms!Form1![Job Title] and [Employee Name] = Forms!Form1![Employee Name];

You can keep all the information on "MyTable" including the 5 answers. You should also keep a date on MyTable so that records for the month can be selected at a later time.

[IKNOWNOSQL]

Morning Peter
I have attached a ZIP file of the DB so far, please see if what you are explaining can be done usign the same DB or do I need to change the structure.

[pdebaets]

Thanks for the file. I don't see that you have the fields above on the tblTransactions, so I don't see a way to use the form with the 4 combo boxes to select the transaction records. You have ID_Staff on the transactions table, but you need the other 3 ID's on there for Area, Branch and Job Title as well. Actually, why do you have Job Title in there? Is a transaction related to a Job Title? And you should be able to derive Branch from the employee selected, since it appears that there is a one-to-many relationship between Branch and Staff. So maybe your tblTransactions just needs ID_Area? Is a transaction for a particular area?

[IKNOWNOSQL]

Thanks Peter

Yes the task at hand will be job title specific as each job title will have diffrent quesitons.

So we will require the Job title to be linked to a form with the appropriate questions.

It is also required because staff movement is very much part of the problem on the report. Some will be placed into acting positions and some will move branches. This will have to be a manual change on the table as we have no communication as to when they are moved or put into other roles.

The branch ID is very important as the Branch Managers and Area Mangers will get monthly feedback on each staff and branch performance reporting to them.

[pdebaets]

You need to spend some time getting your table schema worked out. Don't rush into creating forms before your relational database is normalized. For more info, please see

Fundamentals of Relational Database Design
http://www.deeptraining.com/litwin/d...aseDesign.aspx