In order to simplify the task of any new Webmaster (if there is ever one...), we have created a simplified way to add new data to the Database. Meaning that any new WebMaster would not have to learn the intricacies of more sophisticated programs like 'PhpMy Admin". These new pages do not have the pretense to replace such a sophisticated program but any new WebMaster would not have to learn how to use one of those specialised programs.
Thoses new pages do not have all the features of the 'Big Program', such as the possibility of editing, deleting and other functions, meaning there will no chances of corrrecting mistakes, errors or typos. So, each entry must be correct the first time. There will be reminders at each step to double-check entries for mistakes, errors or typos, before pressing the word "Submit".
Future versions may have those functions.
And in case such mistakes, error or typos did slip through all those checks, the only solution if to go to the original WebMaster and confess of the wroung doing......or to learn 'PhpMy Admin'. But in this case the need for those simplified pages would be irrelevent.
The last few entries to the Database have been done using those pages as a working test.
The Database consists of 2 tables:
the DATA table named "RTW", and
the RELATIONSHIP or DISTRIBUTION table named: "RTW2_2".
If one Pilot had done only one Flight, things would be very simple but as several persons can be in one flight and some can have done several flights, a DISTRIBUTION or RELATIONSHIP table is needed. It will point the name of each person to their respective flight(s). That is the role of the table "RTW2_2".
Example:
(In this example all names and numbers are fictitious and have no connection to the real Database).
John White was in Flight Nunber 1000
Peter Green was also in Flight Nunber 1000
John Black was also in Flight Nunber 1000
Mary Rose was also in Flight Nunber 1000
Mary Rose was also in Flight Nunber 1001
Mary Poppins was also in Flight Nunber 1001
Jiminy Cricket alone in Flight Nunber 1002
From this example, we can see that each name must point to a Flight, but that Mary Rose needs 2 separate entries,
one pointing to Flight 1000 and
one pointing to Flight 1001.
Meaning table RTW has 3 entries, while table RTW2_2 has 7 entries.
In each table, each entry has a successive number:
in table RTW ist is called: Flight Numberor Record_Number and
in table RTW2_2 it is called ID.
In the forms to fill entries for each table, the last number used is given. The RECORD_NUMBER or ID for each new entry is that Number or ID incremented by +1.
Note that in this context, the words: FLIGHT_NUMBER and RECORD_NUMBER are identical.
