Progress Status update page

Please am trying to create a progress status page build with data assist. Everything works fine apart from the update page. What am trying to achieve is that I have progress page where i can click on a record and update user with the current info. Like when i click the update for a record set i can enter a progress - like new location of parcel without overriding the previous update. Basically if I've update the info at 12:00pm with new location london, when i click on update of that record set again i should be able to enter 2:00pm new location kent, without overriding the firsts record since the list of the progress is being view by the client. Please how can i achieve this cause i have the update form and the current status form on the same page.

So far it works when i insert the new info to the form, i can see it in the database but the new updated info is not showing on the update page, although i bind it to that page but it doesn't show but am not sure why it's not showing but i can see the new info inside the database

Your help is much appreciated. Here is link to the testing site.

courier_info_Update.php?ID=34

for what you are trying to accomplish, you wont be updating the existing record, you will be inserting a new record each time


you should have a main table, say for jobs:
jobID - Primary Key
jobName
etc....

then a jobProgress table:
jobProgressID - Primary Key
jobProgressJobID - relates to jobs.jobID
etc....

for each progress, insert a new record and use the jobId value in the jobProgressJobID column

thanks I think i've missed it somewhere. it now works now but the issue am having now is all progress update records are showing. Instead of showing a particular client update. Like use A doesn't have to see the Progress of user B. But now when I update User a progress everything is showing on the the result page. Here is the link courier_info_Detail.php?ID=28

thanks

the job table would need a column to relate to the clients table:

jobID - Primary Key
jobClientID - relates to the clients.clientID column
jobName
etc....


then filter the recordset to return only the selected client.

thanks am still lost a little bit, how do I link them together below is my 2 tables

MAIN TABLE
ID
Consignment_No
Shipment_Type
Courier
Packages
Invoice_No
Product
Quantity
Booking_Mode
Carrier
Carrier_No
Departure_Time
Origin
Destination
Pickup_Date
Pickup_Time
Status



SHIPPING PROGRESS TABLE
ID int(11)
2 Shipment_info_ID
3 New_Status
4 Time
5 Date
6 New_Location
7 New_Comment

what are your relational columns?

both are ID. thank you

but which column relates the progress to the main table?

I taught is meant to be the ID

look at my previous examples


jobID - Primary Key
jobName
etc....

then a jobProgress table:
jobProgressID - Primary Key
jobProgressJobID - relates to jobs.jobID
etc....


the jog table and job progress table both have a primary key column, in the progress table there is a column that relates the progress to the job:
jobProgressJobID

in that column you store the ID value corresponding to the jobs.jobID table to create the relation ship.