why does it only show 1 record?

[Tech]

hi there, i did post this question before but still don't understand. i am a newbie so please, explain in easy words and step by step. thanks.


I have a database of orders etc..

I want to make a query which will to a query on a particular employee, this employee may have dealt with x amount of customers (each employee is set with a group of customers) for example:

EMP1 = Mrs.Walker
Mr.Robin

EMP2 = Mrs. Summers

EMP3 = Mr. Ross
= Mr.Goo

...
...


this query has to get the name of an employee (EG..EMP1 OR Donna) and do a search on the amount of orders they have taken. I then want to calculate commission on the order totals of each customer this employee has dealt with.

I tried to do this (without the calculation part) and it only shows 1 Employee...even if I don't specify a EMP name!

There are relationships, and according to the other thread, i set them as a referential integrity (or something like that)

I started again but nothing

This is what I have in the query:

Customer Details:

Customer Name
Customer Number
Product Name
Unit Price


Product Number:
Product Details


Products Purchased:
Order Number
QTY Purchased


tblEmployee:

Employee ID
Employee Name


Order Form:
Order total


What am I doing wrong?

if u wanna see the database:

ftp://temp:temp@techftpserver.co.uk/mdffc.zip

thanks and plz, explain in easy language!

 

[jfgambit]

There is no database in the attachment. Can you re-attach it??

 

[Tech]

it's there! click on the link.....

ftp://temp:temp@techftpserver.co.uk/mdffc.zip

 

[jfgambit]

This is what I see when the file is unzipped

 

[Tech]

wierd...

try downloading it again. I can't attach it as it's too big... (237kb!)

same url, also try this one, but download ONCE!

www.technosoft2000.co.uk/mdffc.zip

 

[jfgambit]

Just e-mailed the fix to os1@technosoft2000.co.uk

Oh, and I made a change on the form...hope you don't mind.

 

[Tech]

thank-you

firstly..how did u fix it? what was the problem?

secondly, it dont do the query right

cause customer Billy Connoly, Donna Summers (employee) deals with him, not Ahmed Ilyas....

otherwise it works...same with the others too..Betty customer is dealt with employee Ahmed Ilyas, not Brian Ritchie/Donna Summers

 

[jfgambit]

Don't know...just did it...

No, I'm kidding...

You had the CustomerDetail Table linked to the OrderDetail and the EmployeeDetails which was connected to the OrderDetail...which was connected to the ankle bone...which was connected...

Anyway, you had a circular reference so I deleted the link from the CusomterDetail to the Employees and there you go....

In otherwords, your Orders should be connected to your Cusomters and to your Employees, but do not connect the Employees to the Cusotmers.

HTH

 

[Tech]

lol thanks

so u don't know about y the heck the employees are not correctly related to the customer in this search?

 

[jfgambit]

If you want it that way see the e-mail I just sent you.