auto update fields

  • Thread starter Thread starter chad
  • Start date Start date
C

chad

i have a database that has 2 tables and one query what i
need it to do is when the database is opened i need the
employees fields to auto fill with the employees names
instead of having to type them in on daily basis. also i
need it to auto move them up if i was to delete a name
out of the list.

any help would be great and apprieciated.

thanks
 
i have a database that has 2 tables and one query what i
need it to do is when the database is opened i need the
employees fields to auto fill with the employees names
instead of having to type them in on daily basis. also i
need it to auto move them up if i was to delete a name
out of the list.

any help would be great and apprieciated.

thanks
Click to expand...

You're misunderstanding how relational databases work.

You are apparently trying to copy the employee data from the Employees
table to another table on a daily basis. DON'T. Each employee should
have one record in the Employee table with their name, hiredate, etc.
- all the usual bio fields; that information should not exist *in any
other table*, ONLY in the Employee table. That is, the names should be
typed once, when the employee is hired, and left untouched thereafter.

Your other table(s) should contain only the EmployeeID as a link to
the Employees table.
 
-----Original Message-----


You're misunderstanding how relational databases work.

You are apparently trying to copy the employee data from the Employees
table to another table on a daily basis. DON'T. Each employee should
have one record in the Employee table with their name, hiredate, etc.
- all the usual bio fields; that information should not exist *in any
other table*, ONLY in the Employee table. That is, the names should be
typed once, when the employee is hired, and left untouched thereafter.

Your other table(s) should contain only the EmployeeID as a link to
the Employees table.


.
Click to expand...

I think i understand what you are saying but..lets say on
my form i have 36 employees then i have 36 spots next to
each employees name to were i can add how many sales they
had for the day. but lets say "little timmy" which is in
the middle of the list of employees gets fired today. how
would i be able to delete him out and make everyone move
up without it affecting past reports or tables that have
been created. because if i delete an employee out what if
little timmy comes back in 90 days and wants his/her job
back. if i deleted that person out then i wouldn't be
able to pull up old performance reports to see what that
operator/employee did when they were here the first time
around.

i really think that if you looked at my database you
would get a better understanding of what i am trying to
accomplish. if you would like to look at it i have it on
my server at http://myfriendsofmo.com/OperatorReport.zip

i wish i could explain it better but i just don't really
know how to word what i am trying to accomplish.

if you do look at it thanks and even if you don't thanks

chad
 
I think i understand what you are saying but..lets say on
my form i have 36 employees then i have 36 spots next to
each employees name to were i can add how many sales they
had for the day. but lets say "little timmy" which is in
the middle of the list of employees gets fired today. how
would i be able to delete him out and make everyone move
up without it affecting past reports or tables that have
been created. because if i delete an employee out what if
little timmy comes back in 90 days and wants his/her job
back. if i deleted that person out then i wouldn't be
able to pull up old performance reports to see what that
operator/employee did when they were here the first time
around.
Click to expand...

If your Form has thirty-six rows of fixed controls for the thirty-six
employees, and you must redesign the form whenever the employment
roster changes... you're not using Access as a database at all; you'ld
be much better of using a Word document. Just put your thirty-six
employees in a .DOT file and edit it when the personnel change!

That's overly harsh, but you're still misunderstanding.

Your form should be based on a dynamic list of whoever is currently
employed. You do NOT need to or want to change any forms or table
structures or reports when the personnel change. You might have a Form
(a Continuous Form in particular) which displayed 36 rows of data
yesterday, and will display 35 today and 40 next week (when you hire
the five people needed to do Timmy's old job <bg>).

These 36 (or 35, or 40) rows can be based on a Query joining the
employee table to a "DaySales" table by a Left Outer Join; entering
the sales next to a name will create a new record in the DaySales
table for that employee.
i really think that if you looked at my database you
would get a better understanding of what i am trying to
accomplish. if you would like to look at it i have it on
my server at http://myfriendsofmo.com/OperatorReport.zip
Click to expand...

Sorry, that's a bit more than I can tackle right now on a volunteer
basis.
 
Back
Top