Re: I want to put serial number too.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Sat, 12 Nov 2005 05:58:02 -0800, "Kutty"
<Kutty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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]
.

Relevant Pages