I can add that lesson to a temporary user friendly space where it can be approved by

[Nessan123]

Hi all,

I'm designing a database that captures the lessons learned from a set of projects completed by my company. The 'lessons' are broken down into 7 columns.

The database consists of a table of 'projects' and a table of 'lessons'.

The user interface is through a navigation form. This form allows data entry to both the project and lesson tables. There is another form with a keyword search through all the lessons.

+ How do I add a lesson to the database and then leave that lesson 'pending admin approval'. Is there anyway I can add that lesson to a temporary user friendly space where it can be approved by an admin?

Any help would be greatly appreciated.

Nessan

[zmbd]

Nessan123:
Your database may not be normalized enough from the description given.
You should read:[*]> Database Normalization and Table Structures.

It sound as if you might need a few more tables (ordinals are required, sub-ordinals are optional) - this is just one thought:
1) List users (you could also use for supervisors.)
1a) User roles ie: normal, supervisor, auditor, etc...
1b) table assigning roles to users

2) Table that links User, lesson, date taken, approval by, date approved.