Conditional formatting based on a seperate field

  • Thread starter Thread starter jonathan
  • Start date Start date
J

jonathan

We have recently created a safety database for our
organization. Within this db, we have a "Training" table
that contains an "Employee" field, a "Job Category"
field, and 23 seperate "Training" fields. We use a form
to input dates into specific training fields for each
employee. Based on their "Job Category" field, we would
like to mark certain "Training" fields as "Not Required",
or even better, lock out the field for that entire
category.
For example: an employee with a job category
of "administration" would not need to have training for
the "Fire Watch Training" or the "Forklift Operation
Training".

Does anyone know how to do this?

Two concerns that we have noted are: (1) The training
fields are formated as date/time fields, would a "not
required" be able to be inputed at all? and (2) is it
possible to lockout certain bound fields in a form?
 
Your database is not correctly normalized. There should be a separate table
for the 23 Training fields and they should be values in 1 field in that
table. You then need a third table based on a juncture of the first 2 tables
to display a many-to-many relationship. (i.e. 1 employee with 1 category can
have many training records, and each training record can have many
employees.

An example of a many-to-many relationship is the Order Details table in the
Northwind sample database. Have a look at it to see how it is set up.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
So many questions, and one answer - Northwind!
Great database... Just Perfect.
And another great book - Access 2002 Bible.
And Access XP Inside Out.
Take the books, read them, make a separate copy of Northwind, and try to
realize HOW the things are done.
 
Back
Top