By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

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

P: 7
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
Apr 16 '15 #1
Share this Question
Share on Google+
1 Reply


zmbd
Expert Mod 5K+
P: 5,397
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.
Apr 16 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.