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