I have the following problem, I will change the tbl names for ease of explaining.
I have a table called table1. Within this table there are multiple records. There are many records within the table that can belong to a customer.
I want to be able to press a button on a page which will summarise the details of the table, ie, select which ones belong to a particular customer and then update fieldX within the table with an incremental number. The incremental number can belong to any number of records within the table. Hope this makes sense.