I know it has been one here before, but I can not seem to find it.
I want to ba able to make the user go back to the master table once a record is saved.
I have two tables
job with
SELECT
Order_Date,
File_No,
Job_No,
Contract,
Order_Site_Address,
Customer_Name
FROM job
ORDER BY Job_No DESC
and
timesheet with
SELECT
timesheet.Engineer_Name,
timesheet.File_No,
timesheet.TSH_ID,
timesheet.`Date`,
timesheet.Normal_Hours,
timesheet.Time_Half_Hours,
timesheet.Double_Time,
timesheet.Description,
timesheet.Expenses,
timesheet.Completed,
job.Order_Site_Address
FROM timesheet
INNER JOIN job ON timesheet.File_No = job.File_No
When the usre logs in they go to the job list and see a link to timesheet as the timesheet master table is jobs and joined File_No to timesheet.File_No.
So they click on the line that displays the job they have done and it goes to the timesheet list page. From here they click on Add New and it opens up the correct page. Once all the info is put in, they click on save, I need this to go back to the job list so they can search and select the next job use?
Thanks
Paul.