Pls help me in creating a small form data base

[Guest]

My Company has different departments. Department name e.g. : A, B, C, D

I need query telephone number of department in departmentwise.

I assume this will be o.k. in case I arrange thru main form and sub form
basis.
Is there any other better method in access? Pls comment.

 

[Rick B]

No idea what you are asking.

What is the structure of your database? What are you trying to get out of
it?

You want to query telephone number of department? Ok. Do you have both of
those stored in your table? Have you tried to build a query to pull them?
What does "departmentwise" mean?


What does, "in case I arrange thru main form and sub form basis" mean?

 

[Guest]

Dear Rick,

Structure of my database only:
Sure I store datas Departmetn, Name of the person, Tel.No.

Department, Name of the person, Tel.No.
e.g : Once I go to Department A
I have to get all telephone number of department "A" and Name of the person
Once I go to Department B
I have to get all telephne number of department "B" and Name of the person

How I have to build this quiry? I did not build it yet. Now I hope you got
what I mean.

 

[John Vinson]

Dear Rick,

Structure of my database only:
Sure I store datas Departmetn, Name of the person, Tel.No.

Department, Name of the person, Tel.No.
e.g : Once I go to Department A
I have to get all telephone number of department "A" and Name of the person
Once I go to Department B
I have to get all telephne number of department "B" and Name of the person

How I have to build this quiry? I did not build it yet. Now I hope you got
what I mean.

I'd suggest having a table of Departments related one-to-many to a
table of Employees; the Department table would have a unique
DepartmentID and the departmnet name. The Employees table would have a
unique EmployeeID, Surname, Forename, DepartmentID, and Telephone
(assuming each person has only one phone, no cellphones or the like).

You could then use a Form based on Departments, with a continuous
Subform based on Employees to display the employees in that
department.

John W. Vinson[MVP]