using checkbox to update multiple records for order processing

Hi there, I have attached a page that Im trying to add a multiple record update using checkboxes, Not sure if it wont work because the checkbox is outside the form...but had to do this as i have a second form for searching and thought it would go wrong to put it inside the main update form.

So my question is, what steps do I need to take in order to get this page to work?
The functionality of the page is as follows:
1. Form for Searching the records on the page.
2. Using Repeating Table to alternate record css colour.
3. The Form to update record consists of "Ordering Processes, such as Processing, Order Dispatched, Kit Recieved, Kit Delivered and Order Complete)

Ive applied the Form for updating records outside the repeating table for alternating css colours

and in my page layout the search form is alinged to the right and the record update form is aligned to the left.

I guess I am just confused how the whole updating multiple records using checkboxes actually work.

Edit: If I were to put the table that includes the checkboxes inside the updateform then when I click the form submit button even if i just select 1 checkbox it will ignore that and update ALL records.

Please help me :)

Chris

see this tutorial for details on using multiple update:
http://www.webassist.com/tutorials/Create-a-multiple-record-update-form

i'm not sure what you mean about the checkbox, but if a form element is not inside of the form, it is not a part of the form submit.

are you trying to use the checkbook to determine which records get updated? it doesn't work that way, all records. an update page does not update based on what is changed, an update page should pre populate using the original data, then when it submits it adds that data back into the recordset, if you made any changes, it will include those when adding the information back to the database

  i'm not sure what you mean about the checkbox, but if a form element is not inside of the form, it is not a part of the form submit.  

Yes thats exactly what im trying to do so that the admin selects from a select box what order process they want to change selected records to determined by which checkboxes they tick. I got a little confused what you wrote after though. Could you explain a little more or a different way please, because after you said "it doesnt work that way" you then said "all records" so that part threw me :)

All I want is a select box to popular static content (so not from database) and the wording from this select box (order in progress; order dispatched; kit recieved etc) would then be the only field updated when the admin clicks on the submit button of the form. and the only records that will be updated are the ones that the admin selects using the checkbox next to each record that is displayed on the screen.

Chris

multiple updatet does not allow you to select which records get updated.

it will update all records that are being displayed.

the it works is you have a form that sows multiple records.

a recordset is used to repopulate the form


when it submits the information in the form is then added back into the database.

if no changes where made, it will just add the original data back in, if a change was made though, it adds the changes back into the database.

So from what your saying how can achieve what I explained I wanted to do? I see websites all the time allowing users to select which records to update using a checkbox. so not sure why it cannot be achieved?

In case I have explained myself in a way that makes no sense I am attaching a screenshot that hopefully illustrates what I want to code :)

So as you can see Admin selects desired option (static content) from select box) then they will tick desired checkboxes and the click the save submit button and this will update all the checkboxed records with the updated order progress.

The feedback you have given me gives me the impression that this task cannot be done??

Chris

I see, you trying to change only the one column, that's a hourse of a differant color.

have you looked at the multi update tutorials:
http://www.webassist.com/tutorials/Create-a-multiple-record-update-form

http://www.webassist.com/tutorials/Multiple-Updatable-Textfields---Results-Page

Well Jason, its obviously I have a rubbish way of explaining myself ;) Well I had a quick look at some of the related tutorials earlier and had a scan through the forum. But couldn't really find anything related to my workflow. I was wondering from the earlier php file I attached to first post that you could take a look and somehow work your magic in letting me know why its not working as planned...I guess I need to add something to the checkbox code. That would make sense. but I just need a little guiding hand in what steps i need to change or add :)

Chris

Well, the repeat region is not inside a form. meaning that the checkboxes are not contained in a form, and there for cannot be submitted.

you need to have a form around the repeat region and a submit button to trigger the update.



this tutorial:
http://www.webassist.com/tutorials/Multiple-Updatable-Textfields---Results-Page

does match close to what you are trying to do, a multiple update form on a results page.

take a closer look at that one.