Update values from repeated table

[kool_samule]

Hi Chaps,

I have a Query that pulls data from 3 different job tables:

tbl_jobs
- jobid (auto) primary key
- jobinvsent (y,n)
tbl_jobxml
- jobid (auto) primary key
- jobinvsent (y,n)
tbl_jobtrans
- jobid (auto) primary key
- jobinvsent (y,n)

I'm able to present the data in an HTML table, but what I need is the ability to update the values of jobinvsent to 'y' of all the jobid's presented.

I'm guessing I'll need to wrap the table in a form and then post it to a script.php file, but I don't know how to gather all the jobid's in such a way that the scrip file will know which table it came from.

Would really appreciate any help!