close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Progress Status update page

Thread began 3/18/2013 6:59 pm by tolushayoo193471 | Last modified 5/01/2013 10:09 am by Jason Byrnes | 1572 views | 26 replies |

tolushayoo193471

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

tolushayoo193471

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

tolushayoo193471

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

Sign in to reply to this post

Jason ByrnesWebAssist

what are your relational columns?

Sign in to reply to this post

tolushayoo193471

both are ID. thank you

Sign in to reply to this post

Jason ByrnesWebAssist

but which column relates the progress to the main table?

Sign in to reply to this post

tolushayoo193471

I taught is meant to be the ID

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...