hi John,
i would like to create a database for employees who are technicals and
proffissionals
the database contains:
employee name
employee ID
required task<no.>
completed to date<No.>
jun 2007
Feb 2007
March 2007
.......
targete<No>
each employee is under one of three foremen
i want to create good database if you have any idea please
If you have fields named Jun 2007, Feb 2007, etc. then you haven't
read the resource materials I offered. Take a look at the "Database
Design 101" link on Jeff's site.
Also, [Completed to Date] sounds like it should NOT exist in a table,
if it can be calculated on demand from a totals query.
Note that you have not posted *ANYTHING* that would help someone
unfamiliar with your business determine what's required. You're
familiar with the subject; we are not! We don't know what a "task" is,
what it means to be completed, what you mean by "jun 2007" as an
(apparent) field name...
Please, when you compose a post, take a couple of minutes to look at
it, clearing your mind of your own knowledge of the context; read it
as if you had just walked in the door for the first time and knew
nothing about your business. If it doesn't make sense from that
viewpoint, edit it until it does. Thank you!
John W. Vinson[MVP]