I can get my insert into another table on the fly work, however when i create an update on the fly, it creates a new rox in the database rather than update that existing row.
The update of the product works fine but the payments table update creates a new row rather than updating the existing row.
I tried setting it to the session variable at insert of payments table which works great until i log out go to another pc then it wont work when i update as the isnert was done on another computer so cant update based on the insert session variable.
anyone any ideas?
I dont quite understand what you are trying to achieve by logging out and going to another computer?
A session variable is only good until the Sessions are cleared or the web browser is closed (hence it being called Session).
You would need to post your code for people to see why the behavior is inserting, rather than updating. My first thought would be you are using an Insert rather than an Update Server behavior.