I have the following code which displays a table which an engineer can select and alter values. Problem is, the screen on the PDA is very small. I need to be able to break up this select statement into five different parts on a screen, so from the list page there is a link called Basic_Job_Sheet as it is now, but when you go into this Basic_Job_Sheet the next page would be showing The fields in Blue then there would need to be a link to the next part shown in red, then a link to the nect part as shown in green, then a link to show the next part as shown in Purple, then finally a link to shopw the next part as shown in Brown.
This is so the engineers can click through the pages similar to selecting next and getting the next part of a form?
Can this be done?
Thanks
Paul
SELECT
[color=#0000FF]basic_job_sheet.File_No,
basic_job_sheet.TSH_ID,
basic_job_sheet.`Date`,
basic_job_sheet.Normal_Hours,
basic_job_sheet.Time_Half_Hours,
basic_job_sheet.Double_Time,
IFNULL((select Time_Half_Hours1.5), 0) AS Time_Half,
IFNULL((select Double_Time2), 0) AS Time_Double,
(select Normal_Hours+Time_Half+Time_Double) AS TOTAL_HOURS,
basic_job_sheet.Expenses,
basic_job_sheet.Completed,
basic_job_sheet.signature,
[color=#0000FF]basic_job_sheet.Job_No,
basic_job_sheet.Adequate_Access,
basic_job_sheet.Air_Quality_Satisfied,
basic_job_sheet.Electric_Isolated,
basic_job_sheet.Gas_Isolated,
basic_job_sheet.Temperature_Reasonable,
basic_job_sheet.Dangerous_Substances,
basic_job_sheet.Other_Risks,
basic_job_sheet.Safety_Controls,
basic_job_sheet.Work_Details,
basic_job_sheet.Appliance_Details,
basic_job_sheet.Make_Of_Appliance,
basic_job_sheet.Age,
basic_job_sheet.Operating_Pressure_mb,
basic_job_sheet.Operating_Pressure_Input,
basic_job_sheet.Safety_Device,
basic_job_sheet.Air_Supply,
basic_job_sheet.Flue_Flow_Test,
basic_job_sheet.Flue_Spillage,
basic_job_sheet.Visual_Check,
basic_job_sheet.`Serviced_To Schedule`,
basic_job_sheet.Owner_Of_Appliance,
basic_job_sheet.Safe_For_Use,
basic_job_sheet.Gas_Soundness,
basic_job_sheet.Initial_Test_Pressure,
basic_job_sheet.Rest_Pressure_After_Test,
basic_job_sheet.Working_Pressure_At_Meter,
basic_job_sheet.Warning_Notice_Raised,
basic_job_sheet.Installation_Pipework,
basic_job_sheet.Is_Installation_Sound,
basic_job_sheet.Is_Emergency_Control_Access,
basic_job_sheet.Is_Earth_Bonding_Correct,
basic_job_sheet.Is_Installation_Safe,
basic_job_sheet.Electrical_Test,
basic_job_sheet.Earth_Cont,
basic_job_sheet.IR_Phase_To_Earth,
basic_job_sheet.IR_Neutral_To_Earth,
basic_job_sheet.Phase_To_Earth_Loop_Impeadence,
basic_job_sheet.Polarity,
basic_job_sheet.Rccd_Operation,
basic_job_sheet.Correct_Fuse,
basic_job_sheet.Work_Carried_Out,
basic_job_sheet.Materials_Used,
job.Customer_Name
FROM basic_job_sheet
INNER JOIN job ON basic_job_sheet.File_No = job.File_No
ORDER BY basic_job_sheet.Job_No DESC