I want to put serial number too.

[Kutty]

I am creating a contact address in msaccess.
Table 1 : number, employee name, section, designation, extension,
mobile#1, mobile#2, email_address, Notes

Table 2 : Department
Why I want number is : I want every record in autonumber. But I find the
problem that in case I delete any record I cannot assign that number for
another employee.
In the same time if I did not give auto number what will happen ? Is
better auto or without auto number ?

How can I use the field "section" in form ? The section will be under
department.
So logically how this will come in the form?

Another problem is some people will be transferred to another place. I dont
know the department. So shall I mention in the department field that "This
employee is transfered". My worry about this is I mention this in the
department field. Actually "This employee is transfered" is not a part of
department. But this words I can put in Notes field. At that time the
department colum will be empty for those particular rows. What can I do in
this situation. Would appreciate your favor.
I need my contact database with all possible facilities. Please give me
your advise.

(e-mail address removed)


(e-mail address removed)

 

[John Vinson]

I am creating a contact address in msaccess.
Table 1 : number, employee name, section, designation, extension,
mobile#1, mobile#2, email_address, Notes

Table 2 : Department
Why I want number is : I want every record in autonumber. But I find the
problem that in case I delete any record I cannot assign that number for
another employee.
In the same time if I did not give auto number what will happen ? Is
better auto or without auto number ?

If you want to reuse the number, or even have it visible for users at
all, then DON'T use Autonumber.

One thing to consider: if you use a number as an employee ID, and you
have lots of information stored in the tables, on printouts, in
people's minds, on PostIt Notes, about Joe Doaks, Employee #123, you
may not want to reuse Employee #123 after Joe gets fired for
embezzlement and sexual harrassment. It might make for all sorts of
unpleaasant problems for the new Employee #123. Do you REALLY, REALLY
want to reuse the number?

How can I use the field "section" in form ? The section will be under
department.
So logically how this will come in the form?

I don't understand what a "section" is. A Form section? Is a section a
group of people within a department?

Another problem is some people will be transferred to another place. I dont
know the department. So shall I mention in the department field that "This
employee is transfered". My worry about this is I mention this in the
department field. Actually "This employee is transfered" is not a part of
department. But this words I can put in Notes field. At that time the
department colum will be empty for those particular rows. What can I do in
this situation. Would appreciate your favor.

I would create a new department, named "Employee Transfers", and
transfer employees to this "dummy" department.

Information stored in Notes is useful - to human beings who read the
Notes. It is all but useless for linking tables or for updating other
fields in your table!


John W. Vinson[MVP]

 

[Kutty]

I mean "Section" a group of people under department. How can I do this ?
You know that I have Department field in the Form. How to handle the
section

 

[John Vinson]

I mean "Section" a group of people under department. How can I do this ?
You know that I have Department field in the Form. How to handle the
section ?
---------------------------------------------------------------------------------------

First off...

You're worrying about forms TOO SOON.

Data is NOT stored in forms. Forms are just tools, windows that let
you edit data. Get the table structures correct first.

If a person can be in a Section, then you need a Section field in the
table containing people. You will probably also want a table of
Sections, with a DepartmentID field identifying which department a
section is in; there would be a one (department) to many (section)
relationship in the Relationships window.

John W. Vinson[MVP]