The Values are :

a - Admininistrator

u - User

c - Cometition organiser

There then need a personel recored adding so that registration can take place - the personnel record will ho;d the E'Mail Address and type (a,u,c)

There will therefre be a need to change menu from menu to menua menuu menuc

There will then be a restrictiion by q core as to what menus can be seen

Menuu will have an exposure record - revealing the protopage enquiry password

Menuc will have an exposeure record - revealing protopage update record

Note q core passwords are 

Nimrod - for Administartor

lessons - for user

competition - for Competitions

Scott - For Richard - Q Specification  - Hub Structure ( Company Structure) / Registration / Lokhul 

Remember to click the chevron on the right hand side of this page to expose Lesson Pages.

To achieve this functionality we are going to have to maintain the following tables :

1. The establishment table

This maps out the type of people within the organisation. In the golf hub there will be :

1. The Hyper Administrator - Master Password Owner

2. Administrator = has update access to the golf hub

3. Competition Organiser - Self Explanatory

4. User - Information Finder

To map function to establishment we are going to have to maintain a personnel record

1 Personnel Table Containing :

1.1 Email Address

1.2 Password

1.3 Establishment Code

To control access we will need the Access Control Table.  This will map View to Establishment code.

 The Table will contain :

1. Establishment Code

2. View

People with be require to sign in to the dsystem giving us access to their e'mail address and password.

A click event on the menu will determine what view they are trying tp access. If the parameters tsete that they do not have access the system message access denied will need to be displayed - This meand the system message Text box will neeed to be added to all views.

As a person will want to be a user as well as an user there will be an Acting Down Feature where a secondary E.mail Address and password is added to the personnel record.

As a user may want to Act UP to be a Competition Organiser or Administrator the will be acting up details - E'Mail Password as elements to the Personnel file.  Users will be allowed a maximum of 2 acting up codes - Users will not be allowed to act us as the Hyper Administrator this is reserved for the Red Camel Team.

Hays Table.

As this processing is going to be used by Payroll Application in Subsequent releases we will start to record Hays table Grade and Scale As part of the Establishment Table.

This amend that there will be a Payroll Table with:

1. Pay Grade

2. Pay Scale

3. Annual Salary 

Job Accounting

At some time we will introduce Job Accounting and start to record the time that a person is using each view and calculate the cost using payroll hays table information.

This will depend if Richard can provide Forms(View) Load / Forms(View) Exit functions in MVC.

This is a technical Question beyond my experience so the development design of Job Accounting will be down to Richard and Paul. All I know is that there will have to be a table with :

1. Userid (E'Mail)

2. View

3 Start Time

4 End Time

5 Cost of Transaction